How do we rectify this error?
please give the answer with some examples
ORA-22920 row containing the LOB value is not locked
Cause: The row containing the LOB value must be locked before updating the
Action: Lock the row containing the LOB value before updating the LOB value.
for update here will obtain a lock .this should solve your problem.for specific help on the query .post your query here.
Thanx for giving the reply
after putting the for updatae at the end of the select atatement then we are getting the following error
ORA-01002 fetch out of sequence
Cause: In a host language program, a FETCH call was issued out of sequence.
A successful parse-and-execute call must be issued before a fetch. This can
occur if an attempt was made to FETCH from an active set after all records have
been fetched. This may be caused by fetching from a SELECT FOR UPDATE
cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may
also cause this error.
Action: Parse and execute a SQL statement before attempting to fetch the data.