Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-28232:dbms_obfuscation_toolkit.DESEncrypt

ORA-28232:dbms_obfuscation_toolkit.DESEncrypt

From: <katiesoh_at_gmail.com>
Date: 20 Apr 2005 14:47:05 -0700
Message-ID: <1114033625.092926.118530@g14g2000cwa.googlegroups.com>


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
    V_INPUT := :DECRYPT_FILE.TXT_DEC;
  V_INPUT := rpad( V_INPUT, (trunc(length(V_INPUT)/8)+1)*8, chr(0));

  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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US