The XA_RECOVER function returns a list of prepared, committed or rolled-back (but whose information is not discarded) transaction branches from the resource manager.
Syntax
DBMS_XA.XA_RECOVER
RETURN DBMS_XA_XID_ARRAY;
Return values
The return value DBMS_XA_XID_ARRAY defines an array of xid that represent a list of global transaction branches.
Syntax:
TYPE DBMS_XA_XID_ARRAY as TABLE of DBMS_XA_XID
Usage notes
The
TMSTARTSCAN,TMENDSCAN, andTMNOFLAGSflags are not supported.Before you can call
XA_RECOVER, you must be granted theSELECT ON DBA_PENDING_TRANSACTIONSprivilege.