Re: Compilation error

From: Alexey E. Neckrasow <nec_at_leaves.spb.su>
Date: 1997/03/12
Message-ID: <3326D6D0.28B3@leaves.spb.su>#1/1

Hi!

You have to specify the "destination" of select:

create procedure andy as
  c Varchar2 (3);
begin

        select 'aaa' 
	  into c
	   ^^^^^^
	  from dual;

end;
/

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

-- 
Regards. Alexey Neckrasow. Leaves Inc. Russia.
e-mail: nec_at_leaves.spb.su

Received on Wed Mar 12 1997 - 00:00:00 CST