Re: Cursors and Pro*C

From: Paul Beardsell <psb_at_sambusys.demon.co.uk>
Date: Mon, 7 Nov 1994 11:37:55 +0000
Message-ID: <784208275snz_at_sambusys.demon.co.uk>


In article <CyrH8p.sB_at_shellgate.shell.com> ep60wtu_at_shell.com "Wade Tsai" writes:

> Is it possible to fork inside a function which opens a cursor and after
> waiting for the child to complete (child opens another cursor for
> another query (cursor has the same name)), continue processing rows from
> the original cursor? In other words:

[code example deleted]

> Will Oracle be confused as to which cursor the child is referring to?
> Also, how does Oracle Corp. define a session to be? A login or a process?
>
> ANY help/suggestions/pointers would be MUCH appreciated!

The cursor will be invalid in the child. The child will have to connect to Oracle.

> --
>
> Wade Tsai
> -------------------------------------------------------------------------------
> Shell Oil Company, 3-D CAD Group ep60wtu_at_shell.com, (504)-588-6642
>
> My opinions are purely ficticious and does not reflect the opinions of any
> person living, past or present. Any reflection of the opinions of either the
> Shell Oil Company or Digital Consulting is purely coincidental. And boy,
> what a freakin' coincidence THAT would be!
> -------------------------------------------------------------------------------

Your sig is too wide.

-- 
Paul Beardsell                          SAM Business Systems Ltd
~~~~~~~~~~~~~~                          21 Finn House, Bevenden St,
pbeardsell_at_cix.compulink.co.uk          London, N1-6BN, UK.
psb_at_sambusys.demon.co.uk                (+44 or 0)71 608-2391
Received on Mon Nov 07 1994 - 12:37:55 CET

Original text of this message