Re: PL/SQL how-to procedure
Date: 1997/03/31
Message-ID: <01bc3e0a$84fd0220$050264c8_at_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 CEST