Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL how-to procedure
As the PL/SQL manual makes clear, a SQL statement may be defined in a cursor in the Declare and referenced with a FETCH ... INTO ... after opening the cursor, or included directly in the body of the procedure as SELECT .. INTO ...
There is no point in executing a select statement without making use of the returned items and such an operation is not allowed: you MUST select (or fetch) INTO.
Chrysalis.
CG wrote:
>
> ...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
Received on Sat Mar 29 1997 - 00:00:00 CST