Re: Problems with DBMS_OBFUSCATION_TOOLKIT

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Mon, 18 Feb 2002 23:41:55 +0100
Message-ID: <3C718333.955C6B42_at_skynet.be>


Rick Wessman wrote:
>
> Hi:
>
> What you need to do is to explicitly match the arguments with the parameters
> as in:
>
> 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
> arguments as well as strings. The compiler cannot distinguish between the two.
>
> Rick
>
> "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
> 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.

[Quoted] And if I remember well, all parameters used should be initialized to a length that is a multiple of 8.

-- 

Gerard H. Pille

[Quoted] (The Beatles Reunion is neigh!)
Received on Mon Feb 18 2002 - 23:41:55 CET

Original text of this message