Execute Procedure Dynamic

[ales]

Hi,
an example follows.

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.