Newbie Question: Simple Stored Procedure

Greeting All, I have a table schema.table which has many rows of data. I want to write a simple stored procedure that will pull all the rows from this table;

create or replace procedure schema.procedure as
begin
  select * from schema.table
end;
/

When I run the above script I get all kinds of compilation errrors?? Can anyone help me with the above procedure?

Much Thanks, Louis
frolio_at_videoshare.com Received on Thu Mar 30 2000 - 00:00:00 CEST