Re: Nested cursors in Pro*C?

From: James Webster <jamesw_at_cardsetc.com.au>
Date: Tue, 23 Mar 1999 10:52:24 +1100
Message-ID: <36F6D7B8.3EE2894E@cardsetc.com.au>

Ed Prochak wrote:
>
> Do you mean here that maybe you modify tables utilized by CURSOR1?

Ok, within the CURSOR2 loop, the SQL is limited to a fetch.

The additional SQL in the CURSOR1 loop (apart from the CURSOR1 fetches and the CURSOR2 declare, open, fetch and close) involves performing inserts, selects and deletes on both the table used by CURSOR2, and other tables.

If I remove the CURSOR2 loop, everything is fine.

> Also, by "contained within a transaction anyhow" do you imply
> that you are doing a commit before the next fetch of CURSOR1?

No, the transaction is begun before CURSOR1 is DECLARED and the transaction is committed after CURSOR1 is closed, so I _hope_ that transactions are not the issue here!

Ta!
James W. Received on Mon Mar 22 1999 - 17:52:24 CST