PL/SQL Question

Hi,

I have a PL/SQL programming question:

Let's say I have two connections to my database, each being a thread from a calling Java program. Both these threads want to serially access the same info, for example:

SELECT id FROM tab WHERE last_update < '01-jan-99';

Is it possible to open a "global" cursor that allows both connections to retrieve rows, taking turns, from the same open cursor?

For example, connection 1 gets cursor result set rows 1-100. Next, connection 2 gets cursor rows 101-200, then connection 1 gets rows 201-300, and so on.

I'm not quite sure how to do this, or if it can be done.

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 15 2000 - 00:00:00 CST