CREATE OR REPLACE FUNCTION fn_md5(input_string IN 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
DBMS_OBFUSCATION_TOOLKIT.md5(input => raw_input,
checksum => decrypted_raw);
RETURN LOWER(RAWTOHEX(decrypted_raw));
END;[@more@]
raw_input RAW(128) := UTL_RAW.cast_to_raw(input_string);
decrypted_raw RAW(2048);
error_in_input_buffer_length EXCEPTION;
BEGIN
DBMS_OBFUSCATION_TOOLKIT.md5(input => raw_input,
checksum => decrypted_raw);
RETURN LOWER(RAWTOHEX(decrypted_raw));
END;[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/181228/viewspace-1018134/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/181228/viewspace-1018134/