Re: rollback/commit question

From: Dmitry Sirotkin <sdmitry1_at_mail.ru>
Date: Wed, 2 Feb 2000 12:10:07 +0300
Message-ID: <878s25$42l$1@news.rinet.ru>

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 - 03:10:07 CST