md5

CREATE OR REPLACE FUNCTION FN_MD5( MD5_IN_STR IN CLOB)
return VARCHAR
AS
MD5_OUT_STR VARCHAR2(4000);
BEGIN

MD5_OUT_STR:=Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => NVL(MD5_IN_STR,'#')));

RETURN MD5_OUT_STR;
END FN_MD5;