Re: Run command on sqlplus repetitively without reconnection

On 5/21/07, David Taft <oradbt054@xxxxxxxxx> wrote:


Senthil,

Unfortunately the sqlplus session was still running in the background when
I tried the 'print -f exit' inside the trap.  However, that got
me rethinking the problem.  What worked was the the following:



I played with using SQL in coprocesses quite some time ago.
( not a new feature :)

It was kind of fun, but ultimately I couldn't see a good use for it.
It was far easier to just run a sqlplus session than to setup
a coprocess and deal with the vagaries of getting this all
to work properly in the background.  For instance, how do you
tell the coprocess that the output from a script it complete?

Nonetheless, it eventually did work.

You can find a tar file with coprocess functions for use with SQL*Plus
at the bottom of the following page.   It isn't perfect, but it did work
last
time I tried it.

http://jaredstill.com/utilities.html

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: