Re: Global or Static Cursor

From: troy trimble <troyt_at_sun.com>
Date: 1995/05/03
Message-ID: <3o8lqn$361_at_theopolis.orl.mmc.com>#1/1


In article uI_at_netcom.com, csaamb_at_netcom.com (Amadeus M. Burger) writes:
>Is there any way in PRO*FORTRAN or PRO*C to declare a cursor static or
>global?
>
> I am developing a layer to substitute an ISAM record manager
>with Oracle. One of the requirements is for the layer to support a
>function to get the next available record in the selection set
>(sequential reads). This requires that a cursor be shared across
>functions. I haven't been successful at achieving this. Can anyone help?
>
>Thanks in advance.
>--
> csaamb_at_netcom.com

I believe you can define static variables in PL/SQL packages at the package level. You may be able to do the same thing with cursors.

Later,
TT Received on Wed May 03 1995 - 00:00:00 CEST

Original text of this message