exit status of sqlplus???

Hi,

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.

for example:

shell>sqlplus @my_sql_script

...

shell> (as when sqlplus exits, it always give me the exit code 0)

Any suggestion?

Thanks in advance! Received on Wed Feb 19 1997 - 00:00:00 CST