Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

DBMS_CRYPTO encrypt_aes128 + DBMS_CRYPTO chain_cbc + DBMS_CRYPTO pad_pkcs5

SQL> SQL> DECLARE   2     l_enc_val   BLOB;   3     l_in_val    CLOB;   4     l_key       VARCHAR2 (16) := '1234567890123456';   5  BEGIN   6     DBMS_CRYPTO.encrypt (dst      => l_enc_val,   7                          src      => l_in_val,   8                          KEY      => utl_i18n.string_to_raw (l_key, 'AL32UTF8'),   9                          typ      =>   DBMS_CRYPTO.encrypt_aes128  10                                      + DBMS_CRYPTO.chain_cbc  11                                      + DBMS_CRYPTO.pad_pkcs5  12                         );  13  END;  14  / SQL>