Re: Problems with DBMS_OBFUSCATION_TOOLKIT

Hi:

[Quoted] [Quoted] What you need to do is to explicitly match the arguments with the parameters as in:

[Quoted]       DESDecrypt(input_string => v_password, 
                 key_string => v_key,
                 decrypted_string => v_des);

The problem is that DESDecrypt() is overloaded. It can be called with raw [Quoted] arguments as well as strings. The compiler cannot distinguish between the two.

                                 Rick

[Quoted] "SM" <smanduk_at_profidata.com.pl> writes:

> Hi,
>
> Oracle8i (8.1.7 EE), HP-UX
>
> We have problems with DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT procedure.
> While trying to compile a PL/SQL code like this:
>
> PROCEDURE my_encrypt
> AS
> v_password VARCHAR2(20);
> v_key VARCHAR2(7);
> v_des VARCHAR2(300);
>
> BEGIN
> DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT(v_password, v_key, v_des);
> END my_encrypt;
>
> we get the compilation error:
> PLS-00307 too many declarations of 'DESDECRYPT' match this call.
>
> It seems that the number, types and order of parameters passed to the
> procedure are OK.
>
> Any help please ?
>
> Szymon Manduk
>
>
>
>
>

-- 
                                Rick Wessman
[Quoted]                                 Security Assurance Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.