Execute Procedure Dynamic

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!

Hi,
an example follows.

Code:

---

scott@oracle> create or replace procedure jegan0 as
  2  begin
  3    dbms_output.put_line('Test0');
  4  end;
  5  /

Procedure created.

scott@oracle> create or replace procedure jegan(proc_name in varchar2) as
  2  a number;
  3  begin
  4  --......need to execute <> procedure
  5  execute immediate 'begin '||proc_name||'; end;';
  6  dbms_output.put_line('Test');
  7  a := 1000;
  8  dbms_output.put_line('Test >>> a = ' || a);
  9  end;
 10  /

Procedure created.

scott@oracle> exec jegan('jegan0');
Test0
Test
Test >>> a = 1000

PL/SQL procedure successfully completed.

---