shell and sql scripts

[Shivkumar]

Dear Sirs,

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

Thanks,
Shiv

[Sandman! · Accepted solution]

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!

[Arunvijai_4]

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