ORA-22920

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
LOB value.
Action: Lock the row containing the LOB value before updating the LOB value.

Hello

In your dml you gotta use something like this

select * ...........

from ................

for update;

for update here will obtain a lock .this should solve your problem.for specific help on the query .post your query here.

regards
hrishy

Quote:

---

Originally posted by hrishy
Hello

In your dml you gotta use something like this

select * ...........

from ................

for update;

for update here will obtain a lock .this should solve your problem.for specific help on the query .post your query here.

regards
hrishy

---

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.

hello

I think your are using Dynamic sql if so plaese post your entire query here.one of us would give you a solution.

regards
Hrishy