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

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 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx