Re: ORA-28232:dbms_obfuscation_toolkit.DESEncrypt

katiesoh_at_gmail.com wrote:
> 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
>

Sigh.
No version, no platform.

Glass ball says: what characterset?

-- 
Regards,
Frank van Bortel