Re: Compilation error

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!!!!

You CAN'T return results sets from ORACLE stored procedures. You have to SELECT values 'into' variables.

-- 
____________________________________
Oleg Dimerman (olegd_at_e-mail.com)