Re: Problems with DBMS_OBFUSCATION_TOOLKIT

From: No Name <louisparsonsusa_at_netscape.net>
Date: Wed, 13 Feb 2002 15:54:48 GMT
Message-ID: <3C6A7FD0.3010603_at_netscape.net>

This works:
CREATE OR REPLACE PROCEDURE my_encript
IS

    v_password  VARCHAR2(20) := 'tigertigertigert';
    v_key       VARCHAR2(8) := 'scottsco';
    v_des       VARCHAR2(2048);
    v_decrypt   VARCHAR2(2048);

BEGIN
    DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT(input_string => v_password,

                                        key_string => v_key,
                                        encrypted_string => v_des);
    DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT(input_string => v_des,
                                        key_string => v_key,
                                        decrypted_string => v_decrypt);

END;
/

Without the *input_string =>* stuff, it does not work. And of course, the parameters must be initialized!

Louis

Ganesh Raja wrote:

> On Wed, 13 Feb 2002 13:11:59 +0100, "SM" <smanduk_at_profidata.com.pl> wrote:
> 
> 

>>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_string(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
>>
>>
>>
>>
>>

> 
> RTM
> 
> HTH
> 
> 
> 
> [Additions and Corrections Always Welcome.]
> Best Regards,
> Ganesh R
> 

Received on Wed Feb 13 2002 - 16:54:48 CET