Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ORA-28232:dbms_obfuscation_toolkit.DESEncrypt
hello,
I've problem encrypting a diacritic (eg kreäggle) using
dbms_obfuscation_toolkit.DESEncrypt and
dbms_obfuscation_toolkit.DES3Encrypt.
Error message -
ORA-28232: invalid input length for obfuscation toolkit ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 0 ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 9
My input string is right padded in multiple of 8 bytes before passing it to the DESEncrypt procedure.
The following sample code works fine on words other than diacritic.
PROCEDURE DO_ENCRYPT IS
V_ENCRYPT LONG default NULL ; V_DECRYPT LONG default NULL ; V_INPUT LONG default NULL ;BEGIN
dbms_obfuscation_toolkit.DESEncrypt
( input_string => V_INPUT, key_string => :DECRYPT_FILE.TXT_KEY, encrypted_string=> V_ENCRYPT );
:DECRYPT_FILE.TXT_ENC := V_ENCRYPT;
END;
SQL> select length('kreäggle') from dual;
LENGTH('KREDGGLE')
8
Why is it that I'm gettting the ORA-28232 error even though the length of the diacritic above is 8 bytes? Is there any way to handle diacritic?
Thanks in advance.
katie Received on Wed Apr 20 2005 - 16:47:05 CDT