Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Error handling quesiton? SQLPLUS return code in UNIX/NT

Re: Error handling quesiton? SQLPLUS return code in UNIX/NT

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 14 Apr 1999 04:19:07 GMT
Message-ID: <371a1554.17210616@netnews.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US