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

If you are running 11.1.0.7 you can check the preprocessor-feature of external tables.
It might give you everything needed:
first write down your stored script into a file using a DIRECTORY, execute sqlplus as preprocessor with the proper parameters (login!) and the script,
parse the created file as external table.

Never tested, just thought about it.

might it help,
  Martin

Am 03.04.2009 um 20:41 schrieb Jared Still:

> 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




application/pkcs7-signature attachment: smime.p7s