How to know if a script running in SQL*Plus ...

[Hakimca]

Hi All,

Is there a way to know if the script excuted in SQL*Plus fails or not without checking log files manually. In the following example if system_cr_proc.sql fails I don't want to continue.

%binndir%sqlplus %conn% >> system_cr_proc_PL.log system_cr_proc.sql
%binndir%sqlplus %conn% >> sec_cr_proc_PL.log secy_cr_proc.sql
%binndir%sqlplus %conn% >> user_cr_proc_PL.log @user_cr_proc.sql


Thanks

[DaPi]

"WHENEVER SQLERROR EXIT n" will give a return code n to the OS. Works OK in Windoze so it MUST work in UNIX: http://download-west.oracle.com/docs...13.htm#1014742

[Hakimca]

Thanks DaPI