Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Compilation Error
Any Pl/Sql Select has to have a INTO clause if it is not a cursor.
All compilation errors can be seen by SHOW ERRORS command.
Jean wrote:
>
> I have written the following procedure:
>
> create procedure andy as
> begin
> select 'aaa' from dual;
> end;
> /
>
> It compiles with error. I don't understand. Can anyone please enlighten
> me!!!!
>
> Please email me at neoch_at_ntucworld.org.sg
Received on Thu Mar 13 1997 - 00:00:00 CST