I am currently running Oracle9i Enterprise Edition Release 126.96.36.199.0, production with the partitioning option JServer Release 188.8.131.52.0, and production ORACLE_HOME = /oradev01/oracle/product/184.108.40.206.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: , [severe error during PL/SQL execution], , , , , ,  ORA-06544: PL/SQL: internal error, arguments: , , , , , , ,  ORA-06553: PLS-801: internal error 
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):
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  is just a generic message indicating that your PL/SQL block has failed. The ORA-06544  and ORA-06553  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.