Re: PL/SQL how-to procedure
Date: 1997/03/29
Message-ID: <333CDAC1.3863_at_iol.ie>#1/1
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 CET