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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759965253, '216.73.216.133', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/crypto/index(72): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78