To Encrypt or decrypt, we will need a key. This key will be stored in a table which can be accessed only by the authorized personnel.
\nIn the below examples, the key has been hardcoded.<\/p>\n
dbms_crypto example to encrypt information<\/p>\n
l_key varchar2(2000) := '1234567890123456'; l_enc := dbms_crypto.encrypt end;<\/p>\n <\/code><\/p>\n dbms_crypto example to decrypt information<\/p>\n l_key varchar2(2000) := '1234567890123456'; begin<\/p>\n To Encrypt or decrypt, we will need a key. This key will be stored in a table which can be accessed only by the authorized personnel. In the below examples, the key has been hardcoded. dbms_crypto example to encrypt information Declare l_key varchar2(2000) := ‘1234567890123456’; l_mod number := dbms_crypto.ENCRYPT_AES128 + dbms_crypto.CHAIN_CBC + dbms_crypto.PAD_PKCS5; l_enc raw […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[500],"tags":[530,155],"class_list":["post-4338","post","type-post","status-publish","format-standard","hentry","category-sysadmin-api","tag-api","tag-dbms_crypto"],"yoast_head":"\n
\nDeclare<\/p>\n
\nl_mod number := dbms_crypto.ENCRYPT_AES128
\n+ dbms_crypto.CHAIN_CBC
\n+ dbms_crypto.PAD_PKCS5;
\nl_enc raw (2000);
\nbegin<\/p>\n
\n(
\nUTL_I18N.STRING_TO_RAW (p_in_val, 'AL32UTF8'),
\nl_mod,
\nUTL_I18N.STRING_TO_RAW (l_key, 'AL32UTF8')
\n);<\/p>\n
\nDeclare<\/p>\n
\nlv_in_val raw (2000) := hextoraw(p_in_val);
\nl_mod number := dbms_crypto.ENCRYPT_AES128
\n+ dbms_crypto.CHAIN_CBC
\n+ dbms_crypto.PAD_PKCS5;
\nl_dec raw (2000);<\/p>\n l_dec := dbms_crypto.decrypt
\n(
\nlv_in_val,
\nl_mod,
\nUTL_I18N.STRING_TO_RAW (l_key, 'AL32UTF8')
\n);
\ndbms_output.put_line
\n('Decrypted='||utl_i18n.raw_to_char(l_dec));
\nend;
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"