How to fix the Oracle error ORA-26865: must send a COMMIT LCR to end transaction ‘string’ before sending another transaction?

In this post, you’ll learn more about the Oracle ErrorORA-26865: must send a COMMIT LCR to end transaction ‘string’ before sending another transaction with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26865: must send a COMMIT LCR to end transaction ‘string’ before sending another transaction

Reason for the Error ORA-26865: must send a COMMIT LCR to end transaction ‘string’ before sending another transaction

An attempt was made by a client application to send LCRs for a new transaction before sending a COMMIT LCR for the specified transaction.

How to fix the Error ORA-26865: must send a COMMIT LCR to end transaction ‘string’ before sending another transaction ?

You can fix this error in Oracle by following the below steps

Modify the client application to send a COMMIT LCR at the end of the specified transaction.