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>