Oracle MD5 函数

Oracle MD5 函数

===========================================================

作者: wxy0327(http://wxy0327.itpub.net)
发表于: 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;
/