Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: multiple cursors for one table
Charles Stapleton wrote:
> Is there a way I can open multiple cursors into one table, and have them
> remain open simultaneously? I have tried to do this in a Pro*C application,
> and it appears that I can only read form one of these cursors. After
> reading from one, I try to read from another one, and I get no rows
> returned. To test this theory, I switched the order in which I am fetching,
> and found the second ccursor read always resulted in no rows.
I'm either misunderstanding your question or there's something wrong in your code. You can definitely have multiple cursors open that return results from the same table. Can you post a short example that doesn't work for you?
-- Richard KuhlerReceived on Mon Nov 22 2004 - 22:34:44 CST