create or replace procedure myProc
as
begin
  select * from whatever;
end;