SET SERVEROUTPUT ON

DECLARE 
     l_encrypted   RAW(128); 
     l_decrypted   RAW(128); 
     l_key         RAW(128); 
BEGIN 
     l_key := utl_raw.cast_to_raw('IqrbJkR9h7VQsVWk12T60A=='); 
     l_encrypted := dbms_crypto.encrypt(src => utl_raw.cast_to_raw('ID:5031743749436704'),  
                                        typ => dbms_crypto.des3_cbc_pkcs5,  
                                        key => l_key 
                                        ); 
     dbms_output.put_line( UTL_I18N.RAW_TO_CHAR(utl_encode.base64_encode(l_encrypted),'AL32UTF8')); 
     l_decrypted := dbms_crypto.decrypt(src => l_encrypted, 
                                        typ => DBMS_CRYPTO.des3_cbc_pkcs5, 
                                        key => l_key 
                                        ); 
     dbms_output.put_line( UTL_I18N.RAW_TO_CHAR(l_decrypted,'AL32UTF8')); 
END; 

SET SERVEROUTPUT ON

DECLARE 
     l_encrypted   RAW(128); 
     l_decrypted   RAW(128); 
     l_key         RAW(128); 
BEGIN 
     l_key := utl_raw.cast_to_raw('IqrbJkR9h7VQsVWk12T60A=='); 
     l_encrypted := dbms_crypto.encrypt(src => utl_raw.cast_to_raw('ID:5031743749436704'),  
                                        typ => dbms_crypto.des3_cbc_pkcs5,  
                                        key => l_key 
                                        ); 
     dbms_output.put_line( UTL_I18N.RAW_TO_CHAR(utl_encode.base64_encode(l_encrypted),'AL32UTF8')); 
     l_encrypted := utl_encode.base64_decode(utl_i18n.string_to_raw('tKQyG9kMqEMyv28q/dDXfGuWbf+Dnday','AL32UTF8')); 
     dbms_output.put_line( UTL_I18N.RAW_TO_CHAR(utl_encode.base64_encode(l_encrypted),'AL32UTF8')); 
     l_decrypted := dbms_crypto.decrypt(src => l_encrypted, 
                                        typ => DBMS_CRYPTO.des3_cbc_pkcs5, 
                                        key => l_key 
                                        ); 
     dbms_output.put_line( UTL_I18N.RAW_TO_CHAR(l_decrypted,'AL32UTF8')); 
END;