Re: ORA-600 Errors, anyone have a list ?

A copy of this was sent to markp7832_at_my-deja.com (if that email address didn't require changing) On Thu, 02 Dec 1999 19:03:41 GMT, you wrote:

>In article <PUVGODqz8G2HByC=qvZR9cWqXetb_at_4ax.com>,
> jason <jason_at_seahorseNOSPAM.demon.co.uk> wrote:
>> Anyone out there have a list of all the ORA-600 [error] [...] etc
>> errors?
>>
>> I'm interested in digging a little deeper into the internals of
>> Oracle.
>>
>> BTW I've already read Steve Adams "Oracle Internals" book by O'Reilly.
>> ;)
>>
>> Jason.
>>
>I have been told in the past, more than once, by Oracle support that
>there is no list of all 0600 errors. The errors are fairly version
>specific and the same errors have been issued from more than one spot
>in the code which is one reason why support needs not only the full
>parameter list, but often the stack trace module names before they can
>tell you what kind of problem you have.
>
>If you learn different I would be interested in hearing what you learn.

Nope -- that is 100% correct. the same ORA-600[1234] in one version (or even the same version) is/can be very different from ORA-600[1234] in another release. It takes the internal error, its arguments, and the stack trace to figure out where its being flung from. There is no list. Just because you get ORA-600[1234] one day -- does not mean that if you get it later it is the same thing.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Dec 02 1999 - 14:22:42 CST