Xref: alice comp.databases.oracle.tools:16633
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!news.maxwell.syr.edu!firehose.mindspring.net!firehose.mindspring.com!not-for-mail
From: ckrebs <ckrebs@mindspring.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: PL/SQL Stored Procedure & Result Sets
Date: Sat, 19 Sep 1998 10:45:25 -0500
Organization: MindSpring Enterprises
Lines: 17
Message-ID: <3603D195.C611A48B@mindspring.com>
References: <1998082911270600.HAA14410@ladder03.news.aol.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Server-Date: 19 Sep 1998 15:46:27 GMT
X-Mailer: Mozilla 4.05 [en] (WinNT; U)
To: Dieselm <dieselm@aol.com>

Return a RefCursor type out of your proc.

Dieselm wrote:

> Hello,
>
> Is there any way to return a result set in an Oracle stored procedure? I can do
> this easily in MS SQL server by just putting a select statement in the stored
> procedure.
>
> I'm using Oracle 8 on NT.
>
> Thanks,
> Bill