Re: HELP : getting execution status from sqlplus to Unix scripts

"sergio" <gracias_at_logica.com> wrote:

>Hi there,
 

>I have got a Unix shell script running several PL/SQL scripts (via sqlplus)
>sequentially. I would like to exit this shell if any of the PL/SQL scripts
>fails and return an error code to the scheduller which runs this shell.
>Is there an easy way to get the execution status from sqlplus ?

[snip]

Don't forget that an OS error can cause your script to fail but not generate an ORA- error. One example is a when you >SPOOL and are unable to create / write to / close the file.

W/O my manuals I'm helpless but I believe the latest version supports a WHENEVER OSERROR concept.

--
Mark