Re: internal error ora-00600 (4882) on PL/SQL replace or drop command *URGENT*

A copy of this was sent to "bigrez" <resnimi_at_NOSPAMmail.northgrum.com> (if that email address didn't require changing) On Fri, 18 Feb 2000 23:57:12 GMT, you wrote:

>HELP!
>
>I've been developing several procedures for a while now and replacing them
>each time I make a change. This afternoon, a couple of these procedures
>started returning the following error when I try to drop (or replace) them:
>------------------
>SQL> drop procedure rprlist2;
>drop procedure rprlist2
>*
>ERROR at line 1:
>ORA-00600: internal error code, arguments: [4882], [3231984708],
>[3234047636],
>[3231921872], [], [], [], []
>--------------------
>
>All other procedures can be dropped or replaced without any problem - just
>two of them have a problem. Anyone have an idea what this error means and
>how to fix it?
>

I believe you have a recursive dependency. (eg: A depends on B, B on A).

To confirm this and get the solution if that is the case, call support and reference bug 414331.

>Thanks for any help,
>
>Mike Resnick
>LOGICON, Inc.
>resnimi_at_mail.northgrum.com
>

--
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 Sat Feb 19 2000 - 07:38:48 CST