Oracle | DBMS_BLOCKCHAIN

Oracle DBMS_BLOCKCHAIN_UTL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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 (new 20c)

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 (new 21c)

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 (new 20c)

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 (new 20c)

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

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