Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Very strange problem.

Re: Very strange problem.

From: Scarab <yw_at_lucent.com>
Date: Wed, 28 Dec 2005 15:38:49 +0800
Message-ID: <dotfdr$fa9@netnews.net.lucent.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US