RE: dbms_obfuscation package

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 21 Mar 2001 16:38:04 -0800
Message-ID: <F001.002D41B1.20010321144913@fatcity.com>

I do not have the package installed but I found this in the DOC which may help:

If the input data or key given to the PL/SQL DESEncrypt function is empty, then Oracle raises ORA error 28231 "Invalid input to Obfuscation toolkit".

If the input data given to the DESEncrypt function is not a multiple of 8 bytes, Oracle raises ORA error 28232 "Invalid input size for Obfuscation toolkit".

If the user tries to double encrypt data using the DESEncrypt function, then Oracle raises ORA error 28233 "Double encryption not supported by DESEncrypt in
Obfuscation toolkit".

Encryption Procedure Restriction

The DESEncryption procedure has two restrictions. The first is that the DES key length for encryption is fixed at 56 bits; you cannot alter this key length.

The second is that you cannot execute multiple passes of encryption. That is, you cannot re-encrypt previously encrypted data by calling the function twice.

-----Original Message-----
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L

help! I am by no means the world's best PL/SQL programmer (heck, I can barely program in it, PL/SQL 101 is on my desk at home)

I am trying to see how hard it would be to add encryption to sensitive data in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.

I created a table:
SQL> desc test_encrypt

Name                            Null?    Type
------------------------------- -------- ----
COL1                                     VARCHAR2(10)
COL2                                     VARCHAR2(10)

and wrote a quick and dirty PL/SQL anonymous block:

begin
declare

encrypted_str varchar2(10);
inp_string varchar2(10);

begin

inp_string := '123456';
dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);

     insert into test_encrypt values (inp_string,encrypted_str);
     commit;

end;
end;
/

when I run this, I get the following error:

dbms_obfuscation_toolkit.desencrypt (inp_string,'lksdjfasljf',encrypted_str);

*
ERROR at line 7:

ORA-06550: line 7, column 6:
PLS-00307: too many declarations of 'DESENCRYPT' match this call
ORA-06550: line 7, column 6:

PL/SQL: Statement ignored

now, I KNOW that they overload the procedure, they say so in the dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin

but what am I doing wrong that it's not recognizing that I'm using varchar not raw and accepting what I input???

Not urgent, but annoying

Rachel

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rachel Carmichael
INET: carmichr_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------