Re: Rookie question

Hi

What is your procedure supposed to do with the output from your query? It doesn't know and nor do I!

SQL> show errors
3/1 PLS-00428: an INTO clause is expected in this SELECT statement

John

>
>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.
>
>
>
>
>
>
>
>
>
Received on Fri Oct 17 1997 - 00:00:00 CDT