Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: MD5 Error PLS-00307: too many declarations of 'MD5' match this call

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

From: padderz <member633_at_dbforums.com>
Date: Thu, 20 Feb 2003 11:32:47 +0000
Message-ID: <2552879.1045740767@dbforums.com>

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
Received on Thu Feb 20 2003 - 05:32:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US