DBMS_CRYPTO.encrypt_aes128 + DBMS_CRYPTO.chain_cbc + DBMS_CRYPTO.pad_pkcs5 : dbms_crypto « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. dbms_crypto

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>
SQL>