Home » RDBMS Server » Server Administration » Help with Unix/Oracle script.
icon5.gif  Help with Unix/Oracle script. [message #201294] Fri, 03 November 2006 07:14 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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

Re: Help with Unix/Oracle script. [message #201303 is a reply to message #201299] Fri, 03 November 2006 07:35 Go to previous message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Thanks Mahesh for your quick reply.
Previous Topic: convertin html format stroed in CLOB to .DOC file
Next Topic: ORA-12526
Goto Forum:
  


Current Time: Mon Dec 02 07:55:01 CST 2024