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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments