Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback/commit question
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_at_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;
>
>
>
Received on Wed Feb 02 2000 - 17:05:00 CST