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