Database Error Messages

ORA-17371

Replay is disabled because of an active transaction

Cause

An active transaction is detected at the level of a SELECT, PL/SQL, or ALTER SESSION statement, indicating a state that is not safe for replay. This can occur if the transaction state includes TRANSACTION_INTENTION, which signifies the intention to start a transaction, or if an active transaction is ongoing and is not in a read-only state.


Action

Ensure that transactions are either committed or rolled back before executing statements that need to be replayable. Utilizing read-only transactions where possible can also enhance replayability, as these are safer to replay.