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

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 3 Apr 2009 11:41:14 -0700
Message-ID: <bf46380904031141x25cebc07x2c5e08120ac319fc_at_mail.gmail.com>

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.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 03 2009 - 13:41:14 CDT