Re: URGENT , ORA-00600 WHEN DROPING A PACKAGE

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Tue, 08 Jan 2002 03:50:10 -0800
Message-ID: <F001.003E94F3.20020108025019@fatcity.com>

oK . I solved it.
Thing I have done is :
 select obj#,owner#,type# from sys.obj$ where
name = 'package_name';
select select * from procedure$ where obj# in ( obj# of the above query).
I have seen that a row is missing for a obj#  in the second query . And manually inserted it into procedure$ . INSERT INTO procedure$ VALUES

(37767,'-----------------------',NULL,2);

 

Then immediately dropped the package.
It is written in metalink...
Thank you all....
bunyamin karadeniz.
 
 
 

<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Robertson Lee - lerobe To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Tuesday, January 08, 2002 12:20 PM Subject: RE: URGENT , ORA-00600 WHEN DROPING A PACKAGE

  Go
  to Metalink and do a search for your first argument to the 600 error, there a   number of people who have had the same problem as you.   <SPAN
  class=843012010-08012002> 
  <SPAN
  class=843012010-08012002>Regards
  <SPAN
  class=843012010-08012002> 
  <SPAN
  class=843012010-08012002>Lee      

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Bunyamin K. Karadeniz [<A     href="mailto:bunyamink_at_havelsan.com.tr">mailto:bunyamink_at_havelsan.com.tr]Sent:     08 January 2002 09:55To: Multiple recipients of list     ORACLE-LSubject: URGENT , ORA-00600 WHEN DROPING A     PACKAGE
    What can I do ?  Urgent
    please....
     
    SQL>  drop package
    wwsso_home; drop package wwsso_home*ERROR at line     1:ORA-00600: internal error code, arguments: [16201], [], [], [], [],     [], [], []
     
    SQL>  drop package body 
    wwsso_home; drop package body  wwsso_home*ERROR at     line 1:ORA-00600: internal error code, arguments: [16201], [], [], [],     [], [], [], []The
  information contained in this communication isconfidential, is intended   only for the use of the recipientnamed above, and may be legally   privileged. If the reader of this message is not the intended recipient,   you arehereby notified that any dissemination, distribution orcopying   of this communication is strictly prohibited. If you have received this   communication in error, please re-send this communication to the sender   and delete the original message or any copy of it from your   computersystem. Received on Tue Jan 08 2002 - 05:50:10 CST