Hi All,
Please suggest if package can be called in anonymous blocks? how i can call below function in anonymous block?
I tried calling but facing issue that Java method is not allowed here, please advise.
CREATE OR REPLACE PACKAGE get_password
AS
FUNCTION decrypt (key IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END get_password;
/
CREATE OR REPLACE PACKAGE BODY get_password
AS
FUNCTION decrypt (
key IN VARCHAR2,
VALUE IN VARCHAR2)
RETURN VARCHAR2 AS LANGUAGE JAVA
NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
END get_password;
/