From: stephen.bell@sympatico.ca (Stephen_CA)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle RDB stored procedures and resultsets
Date: 7 Jul 2003 11:11:58 -0700
Organization: http://groups.google.com/
Lines: 16
Message-ID: <5aeee507.0307071011.24367fb2@posting.google.com>
References: <3081638.1057588038@dbforums.com>
NNTP-Posting-Host: 64.86.141.143
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1057601519 32676 127.0.0.1 (7 Jul 2003 18:11:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jul 2003 18:11:59 GMT


shamansc <member32508@dbforums.com> wrote in message news:<3081638.1057588038@dbforums.com>...
> I am trying to use RDB stored procedures to return result sets.
> How do I implement this in RDB?  For example  to select all
> employees in a table
> 
> select * from employees
> 
> How would I return a result set from a RDB stored procedure?
> 
> Any help would be appreciated.

Hi,

Check out REF CURSORS.

Steve