Re: Tracking Return Codes from script execution
From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/10/27
Message-ID: <54ulci$hg2_at_client2.news.psi.net>#1/1
Date: 1996/10/27
Message-ID: <54ulci$hg2_at_client2.news.psi.net>#1/1
In article <54laqn$bqr_at_newsb.netnews.att.com>,
govind_at_smtskit.attmail.com (Govindhan Padmavijayam) wrote:
>I would like to know if there's a way to check for return codes from a
>Function execution.
the main problem with the unix shell is its 8-bit-wide return code, featuring values from 0 to 255. oracle errors are all over the range 0 to 99999.
the second problem is that as of your version of sqlplus you cannot capture the error code return from a procedure call in any useful form within a script. the notation "exit sql.sqlcode" sets the error value modulo 256 into the return code; but you cannot write "prompt &sql.sqlcode" because the last error code is not thoughtfully made available as a substitution value.
-- Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.Received on Sun Oct 27 1996 - 00:00:00 CEST