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

##</code><code>##

delete from mytable
  where my_id='12345'
/

insert into anothertable
values ('123456','somedata');
/