OPEN CURSORS AND COMMIT

I have some cursors I use to populate some insert SQL statements. I am not using the 'FOR UPDATE' clause.

I get the invalid fetch error when I attempt to do a rollback.

How can I use cursors in my PL/SQL code with commits and rollbacks. I certainly do not want to have to close any cursors .

Thanks. Received on Mon Sep 13 1999 - 15:45:54 CDT