DBA_Oracle Erp加密和解密账户密码（案例）

CREATE OR REPLACE package APPS.cux_fnd_web_sec authid current_user as

    --加密函数
    function encrypt(key in varchar2, value in varchar2) return varchar2;

   --解密函数
    function decrypt(key in varchar2, value in varchar2) return varchar2;
end;

CREATE OR REPLACE PACKAGE BODY APPS.cux_fnd_web_sec
AS
   FUNCTION encrypt (
      KEY     IN            VARCHAR2,
      VALUE   IN            VARCHAR2
   )
      RETURN VARCHAR2
   AS
      LANGUAGE JAVA
      NAME 'oracle.apps.fnd.security.WebSessionManagerProc.encrypt(java.lang.String,java.lang.String) return java.lang.String';


   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;

SELECT CUX_FND_WEB_SEC.decrypt ('GUEST/ORACLE',encrypted_foundation_password) 
FROM fnd_user WHERE user_name = 'GUEST'

SELECT CUX_FND_WEB_SEC.decrypt ('APPS',encrypted_user_password) 
FROM fnd_user WHERE user_name = 'SYSADMIN'