Urgent: Problem with Cursor for UPDATE

Hello, We have a problem with a cursor for update.

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.

The PL/SQL raise one exception Fetch out of secuence. This is due to we fetch a row before a commit.

The problem is thar in one database that work correctly, but in other one this doesn't work and raise with fetch out of secuence.

¿Anyone knows why?

Thanks.

Elias. Received on Fri May 18 2001 - 05:46:40 CDT