–aes128加密
DECLARE
l_src_data VARCHAR2(20) := 'Source Data';
l_type pls_integer := dbms_crypto.encrypt_aes128 + dbms_crypto.pad_pkcs5 + dbms_crypto.chain_cbc;
l_key VARCHAR2(16) := '0123456789123456';
l_encval raw(2000);
BEGIN
l_encval := dbms_crypto.encrypt( src=>utl_i18n.string_to_raw(l_src_data,'AL32UTF8'), typ=>l_type, KEY=>utl_i18n.string_to_raw(l_key,'AL32UTF8'));
dbms_output.put_line(l_encval);
END;
/
SELECT RAWTOHEX(DBMS_CRYPTO.ENCRYPT(UTL_I18N.STRING_TO_RAW(