Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error handling quesiton? SQLPLUS return code in UNIX/NT
On 13 Apr 1999 16:38:26 GMT, "RABK"
<rkarl_at_consultec-inc.com> wrote:
>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?
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 Received on Tue Apr 13 1999 - 23:19:07 CDT