I have tables x,y,z .
My procedure deletes all the tables and then populates each of them as follows:

Create or Replace procedure Ins as
Delete from x;
Insert into x
select * from tmp;

Delete from y;
Insert into y
select * from tmp2;

Delete from z;
Insert into z
select * from tmp3;


Could you please help me in answering the following questions.

1) How should I error handle if I get errors at each insert stmt. Would the procedure at the error or just give me an error and proceed to the other inserts.
2) How should incorporate the Exception handling, what kind of exceptions should I take care in this code.
3) Should I put Commit statements after each Insert?