have you tried a REF CURSOR ???
"Thorsten Kettner" <thorsten.kettner_at_web.de> escribió en el mensaje
news:74a9c367.0309092336.d39b136_at_posting.google.com...
> 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?
Received on Sat Sep 13 2003 - 19:41:15 CDT
