Re: Run command on sqlplus repetitively without reconnection

On 5/21/07, David Taft <oradbt054_at_gmail.com> 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

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