Oracle | DBMS_BLOCKCHAIN

Oracle DBMS_BLOCKCHAIN_UTL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Utility package support creates blockchain tracking hidden column values.

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_SYSTEM	UTL_RAW
DBMS_BCHAIN_LIB	DBMS_TRANSACTION

Documented No

Exceptions

Error Code	Reason
`ORA-00439`	`feature not enabled: Native DB Blockchain`

First Available 20c

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsbchu.sql

Subprograms

CHAIN_NUM	PROMOTION_TIMESTAMP	TRANSACTION_GUID
IS_COPIER

CHAIN_NUM

Returns the next chain number

May require being called within a blockchain transaction dbms_blockchain_utl.chain_num(owner_name IN VARCHAR2) RETURN PLS_INTEGER;

SELECT dbms_blockchain_utl.chain_num('UWCLASS')

      *

      ORA-00439: feature not enabled: Native DB Blockchain

IS_COPIER

Returns TRUE if the BlockChain utility is in copier mode dbms_blockchain_utl.is_copier RETURN BOOLEAN;

BEGIN

        IF dbms_blockchain_utl.is_copier THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

PROMOTION_TIMESTAMP

Returns the next transaction promotion timestamp

May require being called within a blockchain transaction dbms_blockchain_utl.promotion_timestamp(owner_name IN VARCHAR2) RETURN TIMESTAMP;

SELECT dbms_blockchain_utl.promotion_timestamp('UWCLASS');

      

      DBMS_BLOCKCHAIN_UTL.PROMOTION_TIMESTAMP('UWCLASS')

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

TRANSACTION_GUID

Returns the next transaction global GUID dbms_blockchain_utl.transaction_GUID(owner_name IN VARCHAR2) RETURN RAW;

SELECT dbms_blockchain_utl.transaction_GUID('UWCLASS');

      

      DBMS_BLOCKCHAIN_UTL.TRANSACTION_GUID('UWCLASS')

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