Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Package/function in anonymous block

Orcl ApexOct 26 2016 — edited Oct 26 2016

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;

/

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2016
Added on Oct 26 2016
15 comments
1,695 views