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.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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.
The syntax is as follows:
TYPE DBMS_XA_XID_ARRAY as TABLE of DBMS_XA_XID
Considerations
The
TMSTARTSCAN,TMENDSCAN, andTMNOFLAGSflags are not supported.Before you can call
XA_RECOVER, you must be granted theSELECT ON DBA_PENDING_TRANSACTIONSprivilege.