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.
Ales
The whole difference between a little boy and an adult man is the price of toys