Re: Stored procedure returning records

> 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?

Thorsten,

I have compiled a sample on my homepage which discusses how to 'return a table' from a pl/sql function. You find this here:

    http://www.adp-gmbh.ch/ora/plsql/coll/return_table.html

I hope you find it useful.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch