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 is now availble. If you haven't you downloaded already: Why?

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')

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