Xref: alice comp.databases.oracle.server:83009
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!dispose.news.demon.net!demon!newsfeed.gamma.ru!Gamma.RU!news2.aha.ru!demos!pluscom!not-for-mail
From: "Dmitry Sirotkin" <sdmitry1@mail.ru>
Newsgroups: comp.databases.oracle.server
Subject: Re: rollback/commit question
Date: Wed, 2 Feb 2000 12:10:07 +0300
Organization: RiNet/Cronyx+ news server
Message-ID: <878s25$42l$1@news.rinet.ru>
References: <38977b43.1272342793@news.erols.com>
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 25

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;