MAC v17

The MAC function uses a user-specified MAC function to return the hashed MAC value of a RAW or CLOB value. The MAC function is available in three forms:

MAC
  (<src> IN RAW, <typ> IN INTEGER, <key> IN RAW) RETURN RAW

MAC
  (<src> IN CLOB, <typ> IN INTEGER, <key> IN RAW) RETURN RAW

Parameters

src

src specifies the value for which the MAC value is generated. Specify a RAW, BLOB, or CLOB value.

typ

typ specifies the MAC function used. EDB Postgres Advanced Server supports the MAC functions shown in the table.

key

key specifies the key used to calculate the hashed MAC value.

Examples

This example finds the hashed MAC value of the string cleartext source:

DECLARE
  typ INTEGER := DBMS_CRYPTO.HMAC_MD5;
  key RAW(100) := 'my secret key';
  mac_value RAW(100);
BEGIN

  mac_value := DBMS_CRYPTO.MAC('cleartext source', typ, key);

END;

DBMS_CRYPTO.MAC uses a key value of my secret key when calculating the MAC value of cleartext source.