Oracle Database Errors or Warnings from Error ORA-24781 to ORA-24790
ORA-24781: branches don’t belong to the same global transaction
Cause: The list of xids passed into kpotxmp() don’t have the same gtrid
ORA-24782: Cannot detach from a non-migratable transaction
Cause: An attempt was made to detach from a non-migrateable transaction.
Action: Either commit or rollback the transaction.
ORA-24783: Cannot switch non-migratable transactions
Cause: An attempt was made to prepare/commit a txn different from current.
ORA-24784: Transaction exists
Cause: An attempt was made to start a transaction, while attached to a non-migrateable transaction
ORA-24785: Cannot resume a non-migratable transaction
Cause: An attempt was made to resume a non-migrateable transaction.
ORA-24786: separated transaction has been completed
Cause: The current transaction has been completed by another process.
Action: Start a new transaction
ORA-24787: remote cursors must be closed before a call completes
Cause: The previous operation did not close all the remote cursors it opened. Since separated transactions are enabled, this is not allowed.
Action: Close all remote cursors in each call, or start a regular (non-separated) transaction.
ORA-24788: cannot switch to specified transaction (server type)
Cause: The transaction specified was created by a shared server and the requestor is a dedicated server, or the transaction was created by a dedicated server and the requestor is a shared server.
Action: All parts of this application should connect as dedicated or as shared.
ORA-24789: start not allowed in recursive call
Cause: Oracle RM will not start/resume a branch in a recursive call
Action: Reconsider your application stack design
ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags
Cause: An attempt was made to change the isolation level of an existing transaction.
Action: No action required
Above are list of Oracle Database Errors or Warnings from Error ORA-24781 to ORA-24790 received while performing certain operation against Oracle Database or related products.
What are Oracle Database Error Messages?
Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.
Hope this was helpful.
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.