ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Used to provide an interface to determine if the in-flight transaction on a now unavailable session committed and if the last call on that session successfully completed.
err_server_ahead: the server is ahead, so the transaction is an old transaction and must have already been committed.
-14951
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.
-14952
err_general_failure
First Available
12.1
Security Model
Owned by SYS with EXECUTE granted to the DBA role
Source
{ORACLE_HOME}/rdbms/admin/dbmsappcont.sql
GET_LTXID_OUTCOME
Allows customer applications and third party application servers
to determine the transactional status of the last session when that session becomes unavailable
dbms_app_cont.get_ltxid_outcome(
client_ltxid IN RAW, -- LTXID for JDBC, LogicalTransactionId for ODP.net
committed OUT BOOLEAN,
user_call_completed OUT BOOLEAN);