Re: Stored Procedure return rows ?

In article <91q579$oh9$1_at_nnrp1.deja.com>,   sybrandb_at_my-deja.com wrote:
> In article <91q0qu$lhm$1_at_nnrp1.deja.com>,
> gerald_bastin_at_my-deja.com wrote:
> > Hello,
> >
> > I know it's possible, but I don't know how !.
> > Is anybody can post a very simple sample of a stored procedure which
 do
> > this kind job ?
> > Like a 'select * from emp' returned by a procedure.
> >
> > Thanks for your help !!
> >
> > Gérald
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
> http://osi.oracle.com/~tkyte, topic resultsets.
>
> Please search Deja before you start asking a question which is
 answered
> at least every day.
> Regards,
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ----------------------------------------------------------------------
 --
>
> Sent via Deja.com
> http://www.deja.com/
>

First of all thanks for your help
I have found the article and I have tested the code

CREATE OR REPLACE PROCEDURE "SCOTT"."TEST" (return types.cursortype ) as

    l_cursor types.cursortype ;
begin

    open l_cursor for select ename, empno from emp order by ename;     return l_cursor;
end;

like it's written in the article

I have a compilation error :
Line # = 0 Column # = 0 Error Text = PL/SQL: Compilation unit analysis terminated
Line # = 1 Column # = 37 Error Text = PLS-00201: identifier 'TYPES.CURSORTYPE' must be declared

Any idea ??

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 10:16:53 CST