SQL & PL/SQL

Hi

I have a password proteced winzip file - which I understand to be AES256 encrypted.

I have 'loaded' this file into my 11g database as a BFILE.

I've been trying to decrypt the file using dbms_crypto using this code:

CREATE OR REPLACE FUNCTION DCRYPT2(TO_DECRYPT IN BLOB)

RETURN BLOB

IS

DECRYPTED BLOB;

v_key PLS_INTEGER := dbms_crypto.ENCRYPT_AES256 + dbms_crypto.CHAIN_CBC + dbms_crypto.PAD_PKCS5;

l_key RAW(32) := UTL_I18N.STRING_TO_RAW('T1o_D3ctrr_Feb15', 'AL32UTF8');

BEGIN

dbms_lob.createtemporary(DECRYPTED,true);

DBMS_CRYPTO.DECRYPT(DECRYPTED,TO_DECRYPT,v_key,l_key );

RETURN DECRYPTED;

END;

I then use this function to update my table which contains the BLOB:

UPDATE TESTCRYPT SET D = DCRYPT2(E) 

WHERE ID=1;

This results in:

line 62: ORA-28234: key length too short

Any ideas or help would be very gratefully received!

Thanks