Re: Storing and running a sql script in the database.
Date: Fri, 3 Apr 2009 11:41:14 -0700
On Fri, Apr 3, 2009 at 10:56 AM, Terrian, Thomas J Mr CTR DLA J6DIB < Tom.Terrian.ctr_at_dla.mil> wrote:
> ILogically, it seems that I should be able to store the 5 line script "as
> is" into the database and run it.
Well, maybe someone can enlighten us with a simple way to do this - I can't seem to think of one myself.
It might be possible to pipe this to sqlplus out of dbms_scheduler.
You may want to check that out, I haven't looked closely at it myself.
Certifiable Oracle DBA and Part Time Perl Evangelist