Re: MD5 Error PLS-00307: too many declarations of 'MD5' match this call

DBMS_OBFUSCATION_TOOLKIT.MD5 (and other algorithms) is overloaded for RAW and VARCHAR2 datatypes.

Unfortunately PL/SQL cannot distinguish this overload by TYPE alone (since RAW is subtype of VARCHAR2, hence both are the same TYPE), so you must use named notation to specify overload, for example try...

RETURN DBMS_OBFUSCATION_TOOLKIT.MD5 (input_string => str);

--
Posted via http://dbforums.com