Re: How do I maintain a cursor per client?

From: <bmanry_at_remove.us.oracle.com>
Date: 14 Jul 1998 23:33:59 GMT
Message-ID: <6ogpt7$bcf$1@inet16.us.oracle.com>

Hans Tallis <tallis_at_ers.com> wrote:
[...]
>Is there a way to create a unique cursor per client, that can be kept open
>across subsequent calls? (Or, more generally, a way to return an unbounded
>number of rows to a client.)

Using OCI (Oracle Call Interface) instead of Pro*C will give you finer control over cursors, sessions, etc. It may be a better choice for middleware programming.

/b
--
Bill Manry - IBM Products Division - Oracle Corporation USA These are my opinions, not necessarily Oracle's. Received on Tue Jul 14 1998 - 18:33:59 CDT