when current of

[ligang]

When I use Cursor , inside the cursor loop , I am using
when current of syntax . My question is Can I use commit
after it ?

[ales]

After the loop - yes, inside the loop - NO.

If you use WHERE CURRENT OF you had to open the cursor with the FOR UPDATE clause and this locks all rows selected by this cursor. COMMIT releases all locks and you get the error "fetch out of sequence" after subsequent fetch.

There was a bug up to 816 (I think) that prevented Oracle to report the error in this case so all seemed to be OK.

Ales

[sursujmad]

Hi,

if you use commit inside the loop then the cursor will get closed.

Regards,

[anandkl]

Also if ur performing huge dml activity commiting and then fetching again from with in the loop would result in "snap shot too" old error if your rollback segment is not configured properly.So take care whilc commiting with in the loop.

regards
anandkl