Re: ORACLE error codes

From: -=< a q u a b u b b l e >=- <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com>
Date: Sun, 24 Oct 1999 11:57:46 +0100
Message-ID: <7uuoo4$fh9$1@neptunium.btinternet.com>

Alex Vinokur <alexander.vinokur_at_telrad.co.il> wrote in message news:7uuh5q$13c$1_at_nnrp1.deja.com...
>
>
> Hi,
>
> Is there any header file with all ORACLE error codes,
> What I have found is only $ORACLE_HOME/rdbms/demo/ocidem.h,
> containing only three ORACLE error codes used in demonstration programs.
>
> I would like not to use hard codes (for instance, 1403) in my program,
> but mnemonic codes.
>
> ===============================
> Oracle 8.0.5
> Pro*C/C++ : Release 8.0.5.0.0
> SunOS 5.6
> ===============================
>
> Thanks,
> Alex

Don't know about SunOS, but on our AIX and HPUX boxes, I use oerr ORA-nnnnn from the command line to give me the error message for a code.

You can find the complete listing of error codes and messages in the Oracle documentation: Oracle 7 Server Messages. It's on technet at:

http://http://technet.oracle.com/doc/server73x/MSG73/toc.htm

Why do you want to code for every error? Why don't you find the ones you expect, and then code for WHEN OTHERS, finding out the error code and error message using SQLERRM, etc.?

HTH Received on Sun Oct 24 1999 - 05:57:46 CDT