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-36681: (XSDPART19) Partitions string and string are out of order.

1 Answers  


ORA-09310: sclgt: error freeing latch

1 Answers  


ORA-22808: REF dereferencing not allowed

1 Answers  


ORA-07703: error in archive text: need '/' after device type

1 Answers  


ORA-02704: osndopop: fork failed

1 Answers  


ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted

1 Answers  


ORA-16549: invalid string

1 Answers  


NNL-01001: NAME EXISTS responses received: number

1 Answers  


ORA-00330: archived log ends at change string, need change string

1 Answers  


ORA-07432: unable to perform nested sleep

1 Answers  


ORA-36872: (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.

1 Answers  


ORA-09745: smscre: vm_allocate error, unable to create shared memory.

1 Answers  


Categories