Re: Stored procedure returning records

From: <bsc7080mqc_at_mylxhq-removeme.com>
Date: Wed, 10 Sep 2003 08:47:35 -0400
Message-ID: <61F7b.7156$D82.4423@bignews6.bellsouth.net>

Read up on Cast Array Functions.... no very performant.. but it does what you want. Or you can return a cursor, depending on your need.

On 10 Sep 2003 00:36:35 -0700, thorsten.kettner_at_web.de (Thorsten Kettner) wrote:

>Hi all,
>
>I would like to write a stored procedure that returns records and use
>that like I would use a table or view. For example:
>
> select emp_no, dept_no
> from emps_hired_in(2003)
>
>where emps_hired_in is a stored procedure. We have changed recently
>from Ora 7 to 9i, and I am almost sure this was not possible in Ora 7.
>Is it possible with 9i? If so, how?

MylxHQ - Oracle Resource Portal
http://oracle.mylxhq.com
bsc7080mqc_at_mylxhp.com
(replace mylxhp with mylxhq to reply/contact) Received on Wed Sep 10 2003 - 07:47:35 CDT