Re: Very strange problem.

OK, Thanks for your wonderful reply, that's the problem. And I have some other puzzles:
Can I use "for update" in the declaration of a cursor? cursor icur is
 select rowid from itest
 where (idate < SYSDATE - 30) for update;

If it can:
1. it will only lock the records that fit the criteria and have nothing to do with the other records, is it right? 2. When I commit records after delete 3000 rows,

    if (mod(icur%ROWCOUNT,3000) = 0) then

       commit;
   The cursor is no longer usable because the commit operation, how to workaroud it?

Thank you very much.

"Scarab" <yw_at_lucent.com> wrote in message news:dotcoh$end_at_netnews.net.lucent.com...
> Giridhar,
> My Oracle is 8.1.7, I delete records according to rowid, It work for me. I
> recall your case is also possible, I have ever seen such a case, but the
> error message is not : snapshot too old error, but others which I can't
> remember.
>
> Thanks
>
> "Giridhar" <gkodakalla_at_gmail.com> wrote in message
> news:1135747171.889177.308550_at_o13g a 2000cwo.googlegroups.com...
> > Hi,
> > I have a doubt whether we can have a cursor on the table and open the
> > cursor to delete data
> > from the same table. Will it not cause "snapshot too old error" (1555
> > Error)?
> >
> > Thanks,
> > Giridhar Kodakalla
> >
>
>
Received on Wed Dec 28 2005 - 01:38:49 CST