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-01072: cannot stop ORACLE; ORACLE not running

1 Answers  


IMG-00544: invalid compressionQuality specified

1 Answers  


ORA-30514: system trigger cannot modify tablespace being made read only

1 Answers  


ORA-29380: resource plan string is currently active and cannot be deleted

1 Answers  


PROC-00018: The value size passed is too large

1 Answers  






NNL-00237: Resetting of statistic counters is currently disabled

1 Answers  


RMAN-10009: error logging off of Oracle

1 Answers  


ORA-31436: duplicate change source string

1 Answers  


ORA-38757: Database must be mounted EXCLUSIVE and not open to FLASHBACK.

1 Answers  


PLS-00362: invalid cursor return type; 'string' must be a record type

1 Answers  


LPX-00605: Invalid attribute '~1S' in element '~2S'.

1 Answers  


ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

1 Answers  


Categories