[ORACLE] MD5 패스워드 암호화

/**

 * MD5 암호화 포맷팅

 * @param {String} V_INPUT_STRING: login id

 * @return (String) ENCRYPTED_STRING : Encryped id

 */



CREATE OR REPLACE FUNCTION TOSS."FX_MD5_ENCRYPTION" (V_INPUT_STRING IN VARCHAR2) RETURN VARCHAR2

IS

ENCRYPTED_STRING    VARCHAR2(128);

        BEGIN

        IF V_INPUT_STRING IS NOT NULL THEN

                ENCRYPTED_STRING := LOWER(RAWTOHEX(UTL_RAW.CAST_TO_RAW(DBMS_OBFUSCATION_TOOLKIT.MD5(input_string=>V_INPUT_STRING))));

        END IF;



        RETURN ENCRYPTED_STRING;

 END FX_MD5_ENCRYPTION;

Oracle 프로시저 MD5 암호화 로직