Search notes:

DBMS_CRYPTO

dbms_crypto replaces dbms_obfuscation_toolkit.

PLS-00201: identifier 'DBMS_CRYPTO' must be declared

In order for a user to use dbms_crypto, the user must be granted execution on the package, otherwise, the error PLS-00201: identifier 'DBMS_CRYPTO' must be declared is thrown.
grant execute on dbms_crypto to rene;

Procedures and functions

select distinct
   procedure_name
from
   all_procedures
where
   object_name = 'DBMS_CRYPTO'
order by
   procedure_name
DECRYPT
ENCRYPT
HASH Creates a hash value from a raw, blob or clob.
MAC
PKDECRYPT
PKENCRYPT
RANDOMBYTES Retrns a cryptographically secure pseudo-random sequence of bytes, based on RSA X9.31 PRNG algorithm. Compare with dbms_random which is not cryptographically secure.
RANDOMINTEGER Returns a random integral number in the range of the binary_integer data type.
RANDOMNUMBER Returns a random integral number as number data type.
SIGN
VERIFY

See also

Oracle DBMS PL/SQL packages

Index