Re: Problems with DBMS_OBFUSCATION_TOOLKIT

From: timkarnold <timkarnold_at_home.com>
Date: Wed, 20 Feb 2002 13:14:18 GMT
Message-ID: <KiNc8.74646$8d1.24104180_at_news1.rdc1.md.home.com>


"Gerard H. Pille" <ghp_at_skynet.be> wrote in message news: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.

>

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

> Gerard H. Pille

>
> (The Beatles Reunion is neigh!)

There is a workaround

http://asktom.oracle.com/pls/ask/f?p=4950:8:523861::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:685421699413,%7Bdbms_obfuscation%7D Received on Wed Feb 20 2002 - 14:14:18 CET

Original text of this message