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

From: Martin Berger <>
Date: Sun, 5 Apr 2009 21:43:59 +0200
Message-Id: <>

If you are running 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,

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 <
> > 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


  • application/pkcs7-signature attachment: smime.p7s
Received on Sun Apr 05 2009 - 14:43:59 CDT

Original text of this message