Running a SQL script from a procedure!
From: joe_smile2all <raghurajnair_at_gmail.com>
Date: Tue, 8 Jan 2008 20:29:55 -0800 (PST)
Message-ID: <ae886dd7-b900-4114-95bf-f6662bfbbeca@e10g2000prf.googlegroups.com>
Date: Tue, 8 Jan 2008 20:29:55 -0800 (PST)
Message-ID: <ae886dd7-b900-4114-95bf-f6662bfbbeca@e10g2000prf.googlegroups.com>
Hi!
i am right now using oracle 9i.
i have a procedure named
any_table(p_tablename varchar2)
which i am using to create a .sql file using the UTL_FILE package.that file is again containing the code of another procedure called retrieve .i want to execute the second script so that the procedure retreive gets created....and that too from within the procedure any_table.
can anyone help me to get this done....
thanks.
Received on Tue Jan 08 2008 - 22:29:55 CST