Re: Stored Procedure return rows ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Dec 2000 19:01:58 +0100
Message-ID: <91qsb2$549tp$5@ID-62141.news.dfncis.de>

<gerald_bastin_at_my-deja.com> wrote in message news:91qm1c$6ld$1_at_nnrp1.deja.com...
> 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/

Please read the webpage carefully!
Evidently you forgot to do this

create or replace package types
as

    type cursorType is ref cursor;
end;
/

Regards,

Sybrand Bakker Received on Wed Dec 20 2000 - 12:01:58 CST