DECLARE
--l_rw_encrypted_string raw(2000):='6249B8F6F9B594EB8FC72DA152A40ADC5501C55969AAFDA6600437C9518CBBC0F372858E0ADE212EC1FA67FE2EB7ADC8';
l_rw_encrypted_string raw(2000):='nowi234';
aha EXCEPTION;
PRAGMA EXCEPTION_INIT(aha, -06502);
l_rw_encryption_key raw(32):='6AA28EBC54ECDBCE68791F14AE1BA6901133365DBF9CF5E16C1A55B3E02F78FD';
l_pi_encryption_type pls_integer:=DBMS_CRYPTO.ENCRYPT_AES256+ DBMS_CRYPTO.CHAIN_CBC+ DBMS_CRYPTO.PAD_PKCS5;
l_rw_decrypted_string raw(2000);
l_rw_output_hash_value raw(32);
BEGIN
l_rw_decrypted_string := DBMS_CRYPTO.DECRYPT(l_rw_encrypted_string, l_pi_encryption_type, l_rw_encryption_key);
dbms_output.put_line('Decrypted value=> '||UTL_I18N.RAW_TO_CHAR(l_rw_decrypted_string, 'AL32UTF8'));
EXCEPTION
WHEN aha THEN
RAISE_APPLICATION_ERROR(-20005,'blah ',TRUE);
END;