Re: PL/SQL how-to procedure

From: Shawn Odekirk <shawno_at_erudite.com>
Date: 1997/03/31
Message-ID: <01bc3e0a$84fd0220$050264c8@Shawno.erudite.com>#1/1

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.

Shawn Received on Mon Mar 31 1997 - 00:00:00 CST