ORA-22292: Cannot open a LOB in read-write mode without a
transaction



ORA-22292: Cannot open a LOB in read-write mode without a transaction..

Answer / guest

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. 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00220: controlfile not mounted by first instance, check alert log for more info

1 Answers  


ORA-22979: cannot INSERT object view REF or user-defined REF

1 Answers  


RMAN-20298: DBMS_RCVCAT package not compatible with the recovery catalog

1 Answers  


SQL*Loader-00925: Error while string

1 Answers  


PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

1 Answers  






ORA-08111: a partitioned index may not be coalesced as a whole

1 Answers  


ORA-01725: USERENV('COMMITSCN') not allowed here

1 Answers  


ORA-03125: client-server protocol violation

1 Answers  


DRG-10310: servers were shutdown before processing request

1 Answers  


ORA-13620: The task or object string is read-only and cannot be deleted or modified.

1 Answers  


ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

1 Answers  


ORA-01980: error during OS ROLE initialization

1 Answers  


Categories