PL/SQL版的MD5加密函数

PL/SQL版的MD5加密函数：

 

CREATE OR REPLACE FUNCTION MD5(INPUT_STRING VARCHAR2) RETURN VARCHAR2 IS
  RAW_INPUT     RAW(128) := UTL_RAW.CAST_TO_RAW(INPUT_STRING);
  DECRYPTED_RAW RAW(2048);
  ERROR_IN_INPUT_BUFFER_LENGTH EXCEPTION;
BEGIN
  SYS.DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT    => RAW_INPUT,
                                   CHECKSUM => DECRYPTED_RAW);
  RETURN LOWER(RAWTOHEX(DECRYPTED_RAW));
END;