Q
Problem solve Get help with specific problems with your technologies, process and projects.

Unknown error codes: ORA-00600, ORA-06544, and ORA-06553

I am currently running Oracle9i Enterprise Edition Release 9.2.0.4.0, production with the partitioning option JServer Release 9.2.0.4.0, and production ORACLE_HOME = /oradev01/oracle/product/9.2.0.1.0. I am getting this error in th dump trace log:

*** 2004-08-25 13:32:42.957
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [76607], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [76607]

Here is the current SQL statement for this session:

DECLARE
contact_id NUMBER;
TYPE CURSOR_TYPE_0 IS REF CURSOR;
retcur CURSOR_TYPE_0;
BEGIN
contact_id := 1466;

Now I call the stored program (note: uou have to use SQL Editor to edit and run this program, therefore you cannot use bind variables to pass arguments):

smsweb.userphoneinfo(contact_id,retcur);

Next, it outputs the result:

Unknown cursor return type

If required, I edit the code to display cursor output EXCEPTION WHEN OTHERS THEN:

dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': 
'||SQLERRM, 1, 255)); RAISE; END;

The ORA-600 [15419] is just a generic message indicating that your PL/SQL block has failed. The ORA-06544 [76607] and ORA-06553 [76607] shed more light on the problem. There appear to be a number of bugs relating to these error codes. My suggestion is to apply the latest patchset from Oracle. That typically fixes the problem. And its the first thing Oracle Support would tell you to do.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close