Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-22292

cannot open a LOB in read/write mode without a transaction

Cause

An attempt was made to open a LOB in read/write mode before a transaction was started.


Action

Start a transaction before opening the LOB in read/write mode. One way to start a transaction includes issuing a SQL DML or SELECT FOR UPDATE command. Opening the LOB in read-only mode does not require a transaction.