Re: OCI to PL/SQL Function using Cursor Variables - GPF's
From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/08/25
Message-ID: <4vpu2h$qlt_at_client3.news.psi.net>#1/1
Date: 1996/08/25
Message-ID: <4vpu2h$qlt_at_client3.news.psi.net>#1/1
In article <321E1130.51E8_at_comdisco.com>,
Roderick Prince <rrprince_at_comdisco.com> wrote:
>Trying to prove that it is possible to create a named stored procedure
>(not an anonymous block - plenty of those samples around) that accepts a
>cursor variable and fills it with results.
<educated guess> you cannot pass a cursor from the programmatic environment into the pl/sql environment. i believe that cursors created in pl/sql can be passed around to other pl/sql packages/functions. i doubt that the internal pl/sql structures pointed-to by the cursor are accessible from OCI, since, after all, the stored procedure is executing p-code on the host. not same stacks and heaps at all. <end of educated guess>
-- Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.Received on Sun Aug 25 1996 - 00:00:00 CEST