topic Re: shell and sql scripts in Operating System - Linux

shell and sql scripts

Shivkumar — Thu, 15 Dec 2005 16:33:51 GMT

Dear Sirs,

How can I pass back the status from sql script to shell script ?

Thanks,
Shiv

Re: shell and sql scripts

Sandman! — Thu, 15 Dec 2005 18:37:56 GMT

Shiv,

Assuming you will be running sql commands within sqlplus, which has an "exit" command that will return a status to the calling environment (be it the command line or a shell script). For example:

=================shellscript===================
#!/usr/bin/sh

sqlplus -s user/pass@dbname <.
.
.
exit
EOF

echo $?
=============================================

cheers!

Re: shell and sql scripts

Arunvijai_4 — Thu, 15 Dec 2005 22:22:42 GMT

Hi Shiv, You can easily get to know by shell's default variable "$?" from any shell. If you are using a shell script, just get the value by # echo $?

-Arun