using DBMS_CRYPTO package in reports
510236Feb 4 2009 — edited Feb 4 2009hi all,
i want to encrypt & decrypt user parameter in report.
to encrypt i use;
l_encrypted_raw := dbms_crypto.encrypt(src => my_parameter,
typ => dbms_crypto.des_cbc_pkcs5, key => l_key);
to decrypt;
l_decrypted_raw := dbms_crypto.decrypt(src => l_encrypted_raw,
typ => dbms_crypto.des_cbc_pkcs5, key => l_key);
in sql developer these codes are running. i can encrypt & decrypt
but when i want to decrypt in reports it gives an error like this:
implementation restriction: 'DBMS_CRYPTO.DES_CBC_PKCS5': Cannot directly access remote package variable or cursor
how can i pass this?
thanks...