ttXactIdGet
This procedure returns transaction ID information for
interpreting lock messages. The two result columns of
ttXactIdGet
are used in combination to uniquely identify a transaction
in a database. The first column represents the connection ID and the second column
represents the increasing number of transactions for the same transaction ID. Taken
individually, the columns are not interesting. The result should only be used to correlate
with other sources of transaction information. The numbers may not follow a strict
pattern.
Required Privilege
This procedure requires no privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic.
TimesTen Scaleout applications can call this built-in procedure.
In TimesTen Scaleout, this procedure runs locally on the element from which it is called.
Syntax
ttXactIdGet()
Parameters
ttXactIdGet
has no parameters.
Result Set
ttXactIdGet
returns the result set:
Column | Type | Description |
---|---|---|
|
|
Connection ID. |
|
|
An increasing number that distinguish successive transactions of the same transaction ID. |
Examples
Command> autocommit 0; Command > call ttXactIdGet(); <2,11> 1 row found. Command> commit; Command> call ttXactIdGet(); <3, 12> 1 row found.
Note:
The output correlates to the values printed in lock error messages and ttXactAdmin lock information output.
See Also
- ttXactAdmin
- ttXactIdRollback in Oracle TimesTen In-Memory Database C Developer's Guide