Re: Rookie question

Because you don't tell Oracle what to do with the selected information.

as in:

select * into ...
 from emp_hist;

-- 
------------
Kind reGards
     \ /   |
      X    |
     / \   x
     Gerard

rsenn <rsenn_at_capaccess.org> schreef in artikel
<3446B880.7EA9F732_at_capaccess.org>...


> Can anybody tell me why these statements are generating errors?

>   Thanks.

> 

> SQL> create or replace procedure test

>   2  is

>   3  begin

>   4  select * from emp_hist ;

>   5  end test ;

>   6  /

> 

> Warning: Procedure created with compilation errors.

> 

> SQL> create or replace procedure test

>   2  (v_dummy out number)

>   3  is

>   4  begin

>   5  select * from emp_hist ;

>   6  end test ;

>   7  /

> 

> Warning: Procedure created with compilation errors.

> 

> 

>