PLS-00970: The class name of a method must match that of
EXTERNAL NAME clause in the type header



PLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header..

Answer / guest

Cause: The class name defined as part of the method
signature does not match the one defined in the type header
in the EXTERNAL NAME clause. create type foo as object
EXTERNAL NAME 'foo' LANGUAGE JAVA (... MEMBER FUNCTION my
(number) return number EXTERNAL NAME
'bar.func(oracle.sql.NUMBER) return oracle.sql.NUMBER', .. );

Action: Either omit the class name from the method signature
or use the one defined in the type header.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07491: scgrcl: cannot cancel lock request.

1 Answers  


ORA-06556: the pipe is empty, cannot fulfill the unpack_message request

1 Answers  


NNL-00991: Maximum number of reforwards per request: number

1 Answers  


NID-00440: Database ID for database string changed to number.

1 Answers  


ORA-31517: CDC change table string.string already exists

1 Answers  






ORA-19676: one or more files failed during proxy backup or restore

1 Answers  


LSX-00285: referenced key "~S" is not defined

1 Answers  


TNS-00540: SSL protocol adapter failure

1 Answers  


SQL*Loader-00935: Error verifying required option for parallel load.

1 Answers  


ORA-26721: enqueue of the LCR not allowed

1 Answers  


NID-00450: Succesfully changed database name and ID.

1 Answers  


ORA-28166: duplicate rolename in list

1 Answers  


Categories