Delete records from multiple tables using procedure

Create two tables[mytable1 and mytable2]

mytable1 & mytable2

Create Procedure:

create PROCEDURE multi_delete(id1 number,id2 VARCHAR2)
as 
begin
DELETE MYTABLE1 WHERE MYNO=id1;
DELETE MYTABLE2 where NAME=id2;
end multi_delete;

Execute:

EXECUTE MULTI_DELETE(111,'gabrial');

Select statement:

SELECT * from MYTABLE1;

SELECT * from MYTABLE2;

Output:

mytable1

mytable2