Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OCI client cursor
I think in SQLServer people often have to have seperate connections or only
one statement per connection. In Oracle you can open multiple cursors per
connection. The limitation being the init.ora parameter max_open_cursors=
which is per connection.(I believe that is the parameter) Perhaps this is
some of the confusion.
Jim
-- Our new email address is kennedy-family_at_home.com Have a happy Holiday. "Mike Krolewski" <mkrolewski_at_rii.com> wrote in message news:92qsls$hjs$1_at_nnrp1.deja.com...Received on Mon Jan 01 2001 - 18:05:31 CST
> In article <92pk67$m5r$1_at_nnrp1.deja.com>,
> vityat_at_my-deja.com wrote:
> > Hello!
> > I need to make queries from Oracle( ver 8) , I'm using OCI on Windows
> > NT.
> > I want to get all the result set to my application on the client , so
I
> > can to work on it in my application and free the connection for
another
> > work( another queries).
> > I heard that there are client-side cursor in PL/SQL , but I can not
> > find in the documentation anything.
> > Please help me. How can I do it , with PL/SQL cursors or may be some
> > other way.
> > Thank you in advance.
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> There is alot in the manuals. Look in the application programming under
> OCI for creating cursor.
>
> You can also create client side cursors in PL/SQL. Look for 'ref
> cursor'.
>
> As to your question on freeing up the connection, you cannot free up the
> connection if you are still using a cursor. By definition, the cursor
> requires a connection to continue.
>
> Your problem sounds very vague or you may be misunderstanding the
> operation of OCI. Generally speaking, one opens a connection and leaves
> it open until the application is complete. One can creates, uses and
> closes multiple cursors. One can also create multiple connection (
> multi-threaded operation). Generally speaking a connection does not
> significantly limit the processing of the database. It does consume some
> resources but it should be minimal.
>
> --
> Michael Krolewski
> Rosetta Inpharmatics
> mkrolewski_at_rii.com
> Usual disclaimers
>
>
> Sent via Deja.com
> http://www.deja.com/