Home » SQL & PL/SQL » SQL & PL/SQL » Can't drop storeprocedure.
Can't drop storeprocedure. [message #165] Tue, 22 January 2002 22:50 Go to next message
Phiphat
Messages: 3
Registered: January 2002
Junior Member
Hi,
I want to drop store procedure(Owner is SYSTEM)
but I get the error as below

SQL> drop procedure SM$INTEGRITY_CHK;
drop procedure SM$INTEGRITY_CHK
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [[16201]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]

Should you suggest me to solve the problem.

Thank you for your help.
Phiphat,
Re: Can't drop storeprocedure. [message #166 is a reply to message #165] Wed, 23 January 2002 04:48 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
ORA-00600 internal error code, arguments: [[num]], [[?]], [[?]], [[?]], [[?]], [[?]]

Cause: This is a catchall internal error message for Oracle program exceptions. It indicates that a process has met a low-level, unexpected condition.

Various causes of this message include:

time-outs
file corruption
failed data checks in memory
hardware, memory, or I/O errors
incorrectly restored files

The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of the Oracle Server.

Action: Report this error to customer support after gathering the following information:

events that led up to the error
the operations that were attempted that led to the error
the conditions of the operating system and database at the time ofthe error
any unusual circumstances that occurred before receiving theORA-00600 message
contents of any trace files generated by the error
the relevant portions of the Alert file

Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.
Re: Can't drop storeprocedure. [message #168 is a reply to message #165] Wed, 23 January 2002 07:43 Go to previous messageGo to next message
Ajay Gandhi
Messages: 14
Registered: January 2002
Junior Member
Well, I agree with the previous post. Look into the alert log and see what kind of error messages are popping up. If you get ORA-600, contact Oracle Support.

Re: Can't drop storeprocedure. [message #172 is a reply to message #165] Wed, 23 January 2002 16:07 Go to previous message
Phiphat
Messages: 3
Registered: January 2002
Junior Member
Hi,
Thank you very much .
I try to report the error to customer support of Thailand.
Thank for your help.
Previous Topic: oracle stored procedures and JDBC result sets
Next Topic: Re: Password Change
Goto Forum:
  


Current Time: Thu Mar 28 16:05:37 CDT 2024