XA_RECOVER

The XA_RECOVER function is used to retrieve a list of prepared, committed, or rolled back (but transaction information has not been discarded) transaction branches from the resource manager (RM).

Syntax

DBMS_XA.XA_RECOVER
RETURN DBMS_XA_XID_ARRAY;

Return value

The return value DBMS_XA_XID_ARRAY defines an xid array, which represents the list of global transaction branches.

The syntax is as follows:

TYPE DBMS_XA_XID_ARRAY as TABLE of DBMS_XA_XID

Considerations

• The TMSTARTSCAN, TMENDSCAN, and TMNOFLAGS flags are not supported.

• The user calling XA_RECOVER must be granted the SELECT ON DBA_PENDING_TRANSACTIONS privilege.