Oracle | DBMS_BLOCKCHAIN

Oracle DBMS_BLOCKCHAIN_UTL Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

      FROM dual;

      FROM dual

      *

      ERROR at line 2:

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

      FROM dual;

      

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

      FROM dual;

      

      DBMS_BLOCKCHAIN_UTL.TRANSACTION_GUID('UWCLASS')

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