The Library is currently in the process of being upgraded from Oracle Database Version 220.127.116.11 to
18.104.22.168. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain
references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Provides an interface to determine if the in-flight transaction on a now unavailable session committed or not, and if the last call on that session completed or not.
err_server_ahead: the server is ahead, so the transaction is an old transaction and must have already been committed.
err_client_ahead: the client is ahead of the server. This can only happen if the server has been flashbacked or the ltxid is corrupted. The outcome cannot be determined.
Owned by SYS with EXECUTE granted to the DBA role
Lets customer applications and third party application servers determine the transactional status of the last session when that session becomes unavailable
client_ltxid IN RAW, -- LTXID for JDBC, LogicalTransactionId for ODP.net
committed OUT BOOLEAN,
user_call_completed OUT BOOLEAN)