Re: PL/SQL how-to procedure

Shawn Odekirk wrote:
>
> CG <christian.gregory_at_citicorp.com> wrote in article
> <333C8093.19A5_at_citicorp.com>...
> > ...Can anyone tell me if it is possible to create a procedure
> > with a simple 'select' statement ?... ie. select * from table_a;
> >
> > this select statement will not have an into clause.
> >
> > the reason I ask is that I can't seem to be able to create a procedure
> > unless I have that into clause...
> >
> > Any help is appreciated .... chris
> >
>
> You are right. You can't create a procedure that contains a select statement
> with no into clause.
> Oracle does not support returning result sets from procedures, functions or
> packages. Because of this you need to select all of your results into local
> variables.

But you can create a package which can return a cursor. Received on Sat Apr 05 1997 - 00:00:00 CST