Calling a JAVA STORED PROCEDURE Fails with ORA-904: invalid identifier

(Doc ID 1424331.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.5 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

Calling the following JAVA STORED PROCEDURE is failing with
ORA-00904: "SIDIF_RSA_SIGN"."GETSIGN": invalid identifier:

CREATE OR REPLACE FUNCTION call_java  RETURN VARCHAR2 IS
LANGUAGE JAVA NAME 'Sidif_RSA_Sign.getSign(java.lang.String) return java.lang.String';
/

SQL> select Sidif_RSA_Sign.getSign('test') from dual;
select Sidif_RSA_Sign.getSign('test') from dual
*
ERROR at line 1:
ORA-00904: "SIDIF_RSA_SIGN"."GETSIGN": invalid identifier

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms