ORA-600 internal error code

[nino2000]

Hi ,
I have a big problem with Oracle: Oracle returns:
ORA-00600: code erreur interne, arguments : [15419], [severe error during
PL/SQL execution], [], [], [], [], [], []
ORA-06544: PL/SQL : erreur interne, arguments : [pgm.cgmbiad2()], [102], [],
[], [], [], [], []
ORA-06553: PLS-801: erreur interne [0]

Why means "[]"?
How debug this type of error? Does exists a tools supplied by oracle to debug this?

This error must be caused a function which a java file:

FUNCTION CALL_BEAN_UTIL (cur IN MYTYPEOFCURSOR)
RETURN VARCHAR2
AS LANGUAGE JAVA NAME 'oracle.jsp.dbutil.BeanUtil.translateToHTMLTable(java.
sql.ResultSet) return java.lang.String';

I have a wrong syntax?

 

[sandy2108]

Did u try droping the index. In fact some times it creats problems with the indexes of the table. So if u have index(s) for the table u may drop that, re-create those again. Pl. reply back if the problem persists still.

 

[nino2000]

I work with the table EMP supplied with ORACLE.
How can you know if there are index on EMP table?

I want to create a page JSP which print on the screen the table EMP. I use oracle.jsp.dbutil.BeanUtil . This bean offers a method which return HTML table from a Java Resulset (see

http://globec.gso.uri.edu/jspdocs/javadoc/oracle/jsp/dbutil/BeanUtil.html

for more information)

I deploy BeanUtil into Oracle DataBase.
I create a package which will be called by the Javaserver Page. This package returns the HTML table to the page JSP

The package:
CREATE OR REPLACE PACKAGE TOOLS_HTML
AS
TYPE MYTYPEOFCURSOR IS REF CURSOR RETURN EMP%ROWTYPE;
FUNCTION CALL_BEAN_UTIL (cur IN MYTYPEOFCURSOR)
RETURN VARCHAR2;
FUNCTION LISTE_EMPLOYE RETURN VARCHAR2
END TOOLS_HTML
;


CREATE OR REPLACE PACKAGE BODY TOOLS_HTML
AS

FUNCTION CALL_BEAN_UTIL (cur IN MYTYPEOFCURSOR)
RETURN VARCHAR2
AS LANGUAGE JAVA NAME 'oracle.jsp.dbutil.BeanUtil.translateToHTMLTable(java.
sql.ResultSet) return java.lang.String';

FUNCTION LISTE_EMPLOYE RETURN VARCHAR2 AS
machaine VARCHAR2(32000);
moncurseur MYTYPEOFCURSOR;
BEGIN
OPEN moncurseur FOR SELECT * FROM EMP;
machaine := TOOLS_HTML.CALL_BEAN_UTIL(moncurseur);
RETURN machaine;
END;
END;


The JSP:
[...]
cstmt = conn.prepareCall("begin ?:= TOOLS_HTML.LISTE_EMPLOYE(); end;"
cstmt.registerOutParameter(1,OracleTypes.VARCHAR);
cstmt.execute();
reponse = cstmt.getString(1);
System.out.println(reponse);
}
catch (SQLException e) {
%><%= e.getMessage()%><%}


Oracle compile the package with no error but when I execute with SQL*PLUS:
SQL> DECLARE
2 chaine varchar2(30000);
3 BEGIN
4 chaine:=TOOLS_HTML.LISTE_EMPLOYE();
5 END;
6 /
DECLARE
*
ERREUR à la ligne 1 :
ORA-00600: code erreur interne, arguments : [15419], [severe error during
PL/SQL execution], [], [], [], [], [], []
ORA-06544: PL/SQL : erreur interne, arguments : [pgm.cgmbiad2()], [102], [],
[], [], [], [], []
ORA-06553: PLS-801: erreur interne [0]