Encrypting AES file in Oracle and Decrypting with AESCrypt

Discussion related to AES Crypt, the file encryption software for Windows, Linux, Mac, and Java.
Post Reply
mojtaba.so
Posts: 1
Joined: Fri Nov 15, 2013 10:22 am

Encrypting AES file in Oracle and Decrypting with AESCrypt

Post by mojtaba.so »

Dear friends,

I'm going to send a secured file which is generated in oracle by DBMS_CRYPTO with email to users who should be able to decrypt it by AES Crypt software on Windows. Would you mind assist me to integrate them:
I could encrypt and sent a file in oracle but I couldn't decrypt it on OS. Below PL/SQL script which is used in my script to send an AES encrypted file by email

-- Some unimportant script has been removed here

utl_smtp.write_data( MAIL_CONN, '-------SECBOUND' || utl_tcp.crlf );
utl_smtp.write_data( MAIL_CONN, 'Content-Type: application/octet-stream; charset="windows-1256"' || utl_tcp.crlf );
utl_smtp.write_data( MAIL_CONN, 'Content-Disposition: attachment; ' || utl_tcp.crlf );
utl_smtp.write_data( MAIL_CONN, ' filename="' || 'test.htm.aes' || '"' || utl_tcp.crlf );
utl_smtp.write_data( MAIL_CONN, 'Content-Transfer_Encoding: 8bit' || utl_tcp.crlf );
utl_smtp.write_data( MAIL_CONN, utl_tcp.crlf );

-- Encryption
-- l_file1 is an HTML file
encryption_type := DBMS_CRYPTO.ENCRYPT_AES128 + DBMS_CRYPTO.CHAIN_CBC + DBMS_CRYPTO.PAD_PKCS5;
pass := '1234567890123456';
encrypted_raw := DBMS_CRYPTO.ENCRYPT(src => l_file1, typ => encryption_type,key => UTL_RAW.CAST_TO_RAW(pass));


utl_smtp.write_raw_data( MAIL_CONN, encrypted_raw);
utl_smtp.write_raw_data( MAIL_CONN, utl_raw.cast_to_raw(c_file1));
utl_smtp.write_data( MAIL_CONN, utl_tcp.crlf );
utl_smtp.write_data( MAIL_CONN, utl_tcp.crlf );
utl_smtp.write_data( MAIL_CONN, '-------SECBOUND--' || utl_tcp.crlf );
utl_smtp.write_data( MAIL_CONN, utl_tcp.crlf || '.' || utl_tcp.crlf );
utl_smtp.close_data( MAIL_CONN );
utl_smtp.quit( MAIL_CONN );
Post Reply