Re: exit status of sqlplus???

Wang Chun wrote:
> I tried to run a sql script using sqlplus, however, I could not figure out
> how to check the exit status at the unix shell level of a certain sql script
> to see whether the sql script is successful or failure.

Wang:

sql script:
...
exit 8;

unix script:
sqlplus user/pwd _at_sql_script;
echo "exit status is:" $?

the $? returns the most recent return code.

HTH
janet

(to respond, remove -SPAM-BLOCK) Received on Wed Feb 19 1997 - 00:00:00 CET