Oracle database error code ORA-22292 – Cannot open a LOB in read-write mode without a transaction

Oracle Database Error Code ORA-22292 Description :
Cannot open a LOB in read-write mode without a transaction
Error Cause:
An attempt was made to open a LOB in read-write mode before a transaction was started.

How to Solve :
Start a transaction before opening the LOB in read-write mode. Ways to start a transaction include issuing a SQL DML or SELECT FOR UPDATE command. Opening hte LOB in read-only mode does not require a transaction.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»