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-32342: The EXPLAIN_MVIEW facility failed to explain the materialized view statement

1 Answers  


ORA-01487: packed decimal number too large for supplied buffer

1 Answers  


SQL*Loader-00563: bad length for VAR record

1 Answers  


DRG-51002: unexpected component failure

1 Answers  


ORA-28172: distinguished name not provided by proxy

1 Answers  


LRM-00108: invalid positional parameter value 'string'

1 Answers  


NID-00400: DBNEWID - Completed with errors.

1 Answers  


ORA-22064: invalid NLS parameter string [string]

1 Answers  


ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition

1 Answers  


ORA-13018: bad distance type

1 Answers  


ORA-09924: Can't spawn process - core dump directory not created properly

1 Answers  


DRG-11510: encountered unrecoverable error on line string

1 Answers  


Categories