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