You need to add more information to your question. ANY PL/SQL procedure can execute arbitrarily many independent SQL statements. Simple example:
create or replace procedure my_proc
select sum(price) from sales;
update tax_rates set tax_percent = 0.0875 where state = ‘CA';
delete from sales_history where sale_date < (sysdate() – 180);
What are you really trying to accomplish?