Oracle | DBMS

Oracle DBMS_HASH Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose A PL/SQL admin package for the MD5 hash. The MD5 hash is considered too weak for use, and is too weak for cryptographic use, but may be required for to calculate MD5 hashes.

AUTHID CURRENT_USER

Constants

Name	Data Type	Value

hash_md5	PLS_INTEGER	1

Dependencies

DBMS_HASH_LIB

Documented No

First Available 23ai

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, READ_ONLY);

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmshash.sql
{ORACLE_HOME}/rdbms/admin/prvthash.plb

Subprograms

HASH

HASH (new 23ai)

Undocumented

Overload 1 dbms_hash.hash( dat IN RAW, typ IN PLS_INTEGER) RETURN RAW DETERMINISTIC;

SELECT dbms_hash.hash(utl_raw.cast_to_raw('MORGAN', 1);

      

      DBMS_HASH.HASH(UTL_RAW.CSAT_TO_RAW('MORGAN'), 1);

      -------------------------------------------------

      3BBE782C04300082715F307DD2AF9606

Overload 2 dbms_hash.hash( dat IN BLOB typ IN PLS_INTEGER) RETURN RAW DETERMINISTIC;

TBD

Overload 3 dbms_hash.hash( dat IN CLOB CHARACTER SET ANY_CS, typ IN PLS_INTEGER) RETURN RAW DETERMINISTIC;

TBD