Hi
"need to execute a procedure dynamically."

I get the Procedure name as an input parameter...

this procedure has to be executed...

create or replace procedure jegan(proc_name in varchar2) as
a number;
begin

......need to execute <> procedure
dbms_output.put_line('Test');
a := 1000;
dbms_output.put_line('Test >>> a = ' || a);
end;

I have a table which maintains a list of procedure name that has to be executed. Entries are those of procedures which did not run.

cheers!