Xref: alice comp.databases.oracle.server:83102
Path: alice!news-feed.fnsi.net!netnews.com!feed1.news.rcn.net!rcn!not-for-mail
From: jxs@walaw.com (Jay Scheiner)
Newsgroups: comp.databases.oracle.server
Subject: Re: rollback/commit question
Date: Wed, 02 Feb 2000 23:05:00 GMT
Lines: 38
Message-ID: <3898b7b5.1353365401@news.erols.com>
References: <38977b43.1272342793@news.erols.com> <878s25$42l$1@news.rinet.ru>
X-Trace: gOHTlVuCtl0avaoK7aPUPnibTXDJ+GJx0RLjm3aGoyk=
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 2 Feb 2000 20:01:07 GMT
X-Newsreader:  Forte Free Agent 1.11/32.235

yes, it does have the 'where current of', I was just trying to
abbreviate.

Please comment on other reply to my post, if you could- that I am
committing too frequently.  I have not yet looked at the author's web
site.

Oracle 8i.

On Wed, 2 Feb 2000 12:10:07 +0300, "Dmitry Sirotkin"
<sdmitry1@mail.ru> wrote:

>Hi!
>
>Does your UPDATE statement contain "WHERE" clause, fE "WHERE CURRENT OF
><cursor_name>" ? If it does this behavior is very strange, 'cos 500 updates
>in one transaction is not too big task for Oracle. And you forgot to publish
>the version of Oracle you're using.
>
>Dmitry Sirotkin.
>
>>I have a PL/sql procedure something like
>>(cursor defined)
>>loop
>>  get cursor rec
>>  update cursor.column = value
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>>  cnt:=cnt+1;
>>  if cnt > 500 then
>>      commit;
>>      cnt :=0;
>>  end if
>>end loop
>>commit;
>
>
>