Re: Storing and running a sql script in the database.

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
  • 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@xxxxxxx> 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.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: