Requirement to generate a procedure text when a procedure is executed
Could you please help me on the below requirement
I have a requirement where in , based on the Input data to a procedure and upon its execution it should again generate another plsql procedure itself
that is
For example
Create procedure P1_Ex(XX_Table varchar2,XX_col varchar2)
is
begin
-- Write the utl_file and put the code in the data like
utl_file(file_type,'Create procedure p1_generated is'||chr(10)||'is'||chr(10)||'Begin '||chr(10)||'null;'||'end;');
end;
So upon running the program , i get a file which will contain procedure , which i can execute it later.