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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
