Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: multiple cursors for one table

Re: multiple cursors for one table

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 23 Nov 2004 04:34:44 GMT
Message-ID: <E5zod.57967$hN1.46363@twister.socal.rr.com>


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 Kuhler
Received on Mon Nov 22 2004 - 22:34:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US