PL/SQL (MOSC)

MOSC Banner

Requirement to generate a procedure text when a procedure is executed

edited Jul 4, 2013 5:51AM in PL/SQL (MOSC) 1 commentAnswered
Hi,
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center