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

Related Topics
Built-in Functions
Built-in Packages
Database Security
BlockChain Tables
DBMS_BLOCKCHAIN_TABLE
DBMS_TABLE_DATA
DBMS_USER_CERTS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx