Re: List of Oracle Errors

From: suzilem <suzilemNOsuSPAM_at_aol.com.invalid>
Date: 2000/05/24
Message-ID: <0c02b520.64ee41e6@usw-ex0102-014.remarq.com>#1/1

If you're on a Unix platform you can use the "oerr" utility. Syntax is: oerr <prefix> <number>
in your case: oerr ORA 6552
%s -- the error message should have returned a string Sometimes, Oracle error messages are less than informative... ;^)

/> oerr ora 6552
06552, 00000, "PL/SQL: %s"

// *Cause:
// *Action:
/> oerr ora 6553

06553, 00000, "PLS-%s: %s"

// *Cause:
// *Action:
/>

You can also go to Oracle technet and access the error manual there.

In article <noeois8bgodv3tq10lsblndrb8as5jr7m4_at_4ax.com>, Steve . <syarbrou_at_nospam.enteract.com> wrote:
>I have Oracle 8i and on occasion get ORA- error messages. Is
 there
>somewhere that list each error message and what is actually
 causing
>this? It would save a lot of troubleshooting time. I have
 several
>DBA and Troubleshooting books and they only seem to list a
 few. Right
>now I'm getting the following:
>
>ORA-06552
>ORA-06553
>
>Thanks.
>
>Steve
>
>Newsgroup replies preferred. Remove nospam when replying thru
 email.
>
>

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Wed May 24 2000 - 00:00:00 CDT