 Help with Unix/Oracle script. [message #201294] |
Fri, 03 November 2006 07:14  |
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
|
Member |
|
|
Hello All,
I have a situation where i have to start a SQL script when an unix process is completed. In other words, I want to kick off an SQl script once a UNIX process is completed. I would greatly appreciate if anyone helps me out writing this script.
Thanks,
Vikram
|
|
|
|
| Re: Help with Unix/Oracle script. [message #201299 is a reply to message #201294] |
Fri, 03 November 2006 07:20  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Is this 'unix process' just another script?
Is it scheduled as a batch job?
then, use a wrapper script.
something like this
#!/bin/bash
the_unix_script
sqlplus -s user/pass <<EOF
your sql;
exit;
EOF
If the said process is not scheduled as a job then
see if you can log the status of unix script somewhere.
If you are happy with status,kick this script.
[Updated on: Fri, 03 November 2006 07:21] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
