Re: Result Sets from stored procedures

From: Steven Whatley <swhatley_at_blkbox.com>
Date: 1997/06/10
Message-ID: <5nkhbl$isj@news.blkbox.com>#1/1

To: tkyte_at_us.oracle.com
Subject: Re: Result Sets from stored procedures Cc: swhatley
Newsgroups: comp.databases.oracle.misc
In-Reply-To: <01bc7080$83c54680$02010101_at_johna.teamsinc.com> <3398b41b.2014216_at_newshost>

In article <3398b41b.2014216_at_newshost> you wrote:
: On 3 Jun 1997 17:44:00 -0700, "Superman" <amir_at_neta.com> wrote:
: >Does 7.3 allow result sets to be returned from stored
: >procedures/functions/packages?
:
: With 7.2 and 7.3 you have cursor variables. Cursor variables are cursors opened
: by a pl/sql routine and fetched from by another application or pl/sql routine
: (in 7.3 pl/sql routines can fetch from cursor variables as well as open them).
: The cursor variables are opened with the privelegs of the owner of the procedure
: and behave just like they were completely contained within the pl/sql routine.
: It uses the inputs to decide what database it will run a query on.

This is interesting. Didn't know about referenced cursors. But, I can't get the line:

SQL> variable C refcursor
Usage: VARIABLE [ variable [ NUMBER | CHAR | CHAR (n) |

                             VARCHAR2 | VARCHAR2 (n) ] ]

SQL> to work. The start of my SQL*Plus is as follows:

Connected to:
Oracle7 Server Release 7.2.3.0.0 - Production Release With the distributed, replication and parallel query options PL/SQL Release 2.2.3.0.0 - Production

SQL> Should REFCURSOR work with this version of SQL*Plus?

Thanks,
Steven
http://www.blkbox.com/~swhatley/

                      _|_  |  _|_   "I am the way and the truth and
Steven Whatley         | --|-- |    the life.  No one comes to the
swhatley_at_blkbox.com    |   |   |    Father except through me."
Houston, Texas             |            -- Jesus Christ (John 14:6 NIV)
                           |

Received on Tue Jun 10 1997 - 00:00:00 CDT