Re: SQL.SQLCODE

In article <4ebobe$sum_at_reader2.ix.netcom.com>, Chuck Hamilton <chuckh_at_ix.netcom.com> writes
>surman_at_oracle.com (Scott Urman) wrote:
>
>But the ORACLE error reported while in SQLPLUS (ORA-????) is not the
>same as the error code returned by SQL.SQLCODE when it exits back to
>the shell. They're entirely different numbers. I need to find out what
>the SQL.SQLCODE error #'s mean.
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
>
>If at first you don't succeed, sky-diving isn't for you.
>

The shell can only cope with 8-bit return codes and oracle error codes are 16-bit. SQLCODE is therefore truncated and the exit code is not meaningful.

-- 
Jim Smith