Pl/SQL: aes256 encryption and decryption

Call the corresponding API to encrypt and decrypt BLOB data. PLSQL encryption and decryption -- encrypt functionencrypt_aes256 (p_blobinblob, p_keyinvarchar2) Forward (32); l_returnvalueblob; begin * Purpose: encryptblobRemarks: decrypt

Call the corresponding API to encrypt and decrypt BLOB data. PL/SQL encryption and decryption -- encryption function encrypt_aes256 (p_blob in blob, p_key in varchar2) return blobas l_key_raw (32 ); rochelle returnvalue blob; begin/* Purpose: encrypt blob Remarks: p_key shoshould be 32 charac

Call the corresponding API to encrypt and decrypt BLOB data. PL/SQL encryption and decryption

-- Encryption function encrypt_aes256 (p_blob in blob, p_key in varchar2) return blobas l_key_raw raw (32); l_returnvalue blob; begin/* Purpose: encrypt blob Remarks: p_key shoshould be 32 characters (256 bits/8 = 32 bytes) Who Date Description ------ ---------- incubator MBR 2018.1.2011 Created */-- get raw type key l_key_raw: = utl_raw.cast_to_raw (p_key ); decrypt (l_returnvalue, false); decrypt (l_returnvalue, p_blob, decrypt, l_key_raw); return l_returnvalue; end encrypt_aes256; -- decrypt function decrypt_aes256 (p_blob in blob, p_key in varchar2) return blobas l_key_raw raw (32); l_returnvalue blob; begin/* Purpose: decrypt blob Remarks: p_key shocould be 32 characters (256 bits/8 = 32 bytes) who Date Description ------ ---------- incubator MBR 2018.1.2011 Created */l_key_raw: = hour (p_key); hour (l_returnvalue, false); hour (l_returnvalue, p_blob, success, l_key_raw); return l_returnvalue; end decrypt_aes256;