Oracle MD5 函数
===========================================================
作者: wxy0327(http://wxy0327.itpub.net)
发表于: 2006.09.29 17:43
分类: Oracle
出处: http://wxy0327.itpub.net/post/16888/214796
---------------------------------------------------------------
发表于: 2006.09.29 17:43
分类: Oracle
出处: http://wxy0327.itpub.net/post/16888/214796
---------------------------------------------------------------
源代码:
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;
/