|
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.
----- Original Message -----
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.
Regards
Lee
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 is
confidential, is intended
only for the use of the recipient
named above, and may be legally
privileged. If the reader
of this message is not the intended recipient,
you are
hereby notified that any dissemination, distribution or
copying
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
computer
system.
|
