How to
get error return code to Unix?(s19)
Does anyone have a code snipet of UNIX that looks at return codes
from SQLPLUS? Is there a success or failure return on SQLPLUS for
UNIX to use or is it all within SQLPLUS that error checking should
be done?
Whats the best method to use in automated PL/SQL scripts for Oracle?
Ans1:
If you issue this SQL*Plus command:
whenever sqlerror exit failure
Then any SQL errors will cause a failure status to be returned to Unix.
Jonathan