Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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.comReceived on Thu Feb 20 2003 - 05:32:47 CST