OB_TRANSACTION_ID

Syntax

OB_TRANSACTION_ID()

Purpose

• If the current session is in an active transaction, this function returns the integer value of the transaction ID, which is greater than 0.
• If the current session is not in an active transaction, this function returns 0.

Examples

1. Start a transaction.

   obclient [SYS]> START TRANSACTION;
   

2. Query the transaction ID of the active transaction.

   obclient [SYS]> SELECT OB_TRANSACTION_ID() FROM DUAL;
   

   The returned result is as follows:

   +---------------------+
   | OB_TRANSACTION_ID() |
   +---------------------+
   |            11003721 |
   +---------------------+
   1 row in set
   

3. Commit the transaction.

   obclient [SYS]> COMMIT;
   

4. Query the transaction ID of the non-active transaction.

   obclient [SYS]> SELECT OB_TRANSACTION_ID() FROM DUAL;
   

   The returned result is as follows:

   +---------------------+
   | OB_TRANSACTION_ID() |
   +---------------------+
   |                   0 |
   +---------------------+
   1 row in set