Stored procedure to execute multiple procedures in a sequential order

See more:

SQL

I have a requirement to run multiple pl sql procedures in a sequential order by scheduling in DBMS_Scheduler. Can we accomplish it by creating main proc by calling all these procs to run sequential order and the execution gets stopped if any of the proc gets failed
Also i'd like to capture the exception handling as well?

What I have tried:

CREATE OR REPLACE

PROCEDURE RUN_JOBS AS

BEGIN

PROCEDURE1;

PROCEDURE2;

PROCEDURE3;

PROCEDURE4;

PROCEDURE5;

exceptions

when others then

dbms_output.put_line('error::'||SQLERRM);

err_num := SQLCODE;

err_msg := SUBSTR(SQLERRM, 1, 100);

insert into tmp_log (no,err_message) values(1,SQLERRM);

END;

/