Re: Urgent: Problem with Cursor for UPDATE

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Fri, 18 May 2001 12:11:10 GMT
Message-ID: <3b050f80.12803935@news-server>

On Fri, 18 May 2001 12:46:40 +0200, "Elias Alpuente" <ealpuente_at_isoco.com> wrote:

>We have a stored procedure with a cursor for update on one table.
>This cursor fetch a row and update it with WHERE CURRENT OF
>clause. We make a COMMIT each 500 rows procesed.
>

That kills it. You must not use a CURRENT OF after a commit. Particularly if what you are updating is the table where you are doing the CURRENT OF. Might work sometimes, but ORACLE specifically advises against it. It's in the "manuel".

In Steve's site, www.ixora.com.au, there is plenty of info on this.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri May 18 2001 - 07:11:10 CDT