Re: Program interacting with SQL*Plus

From: David Simpson <dsimpson_at_dotcomsolutionsinc.net>
Date: Sun, 30 Jun 2002 04:01:14 GMT
Message-ID: <dovT8.352640$352.42589_at_sccrnsc02>


David,
[Quoted] Here is a script which I use on Solaris to monitory standby databases which could give you some ideas for accomplishing your sqlplus tasks: http://www.dotcomsolutionsinc.net/products/installgen/sol_901_32bit_files/in stallgen_sol901_79_.html

This is a Perl script, but the same ideas could be performed with shell scripts too.

David Simpson
www.dotcomsolutionsinc.net

"David Van Horn" <david_at_vanhorn.com> wrote in message news:f3f332ed.0206291836.58ab23b4_at_posting.google.com...
> Hello,
>
> I am writing a shell script that needs to start SQL*Plus and then pass
> strings to SQL*PLUS and read output (in much the same way a person
> would interact with SQL*Plus).
>
> How is this accomplished on Oracle 8i?
>
> Thank you,
> David Van Horn
>
> --
> dvanhorn at cs dot uvm dot edu
Received on Sun Jun 30 2002 - 06:01:14 CEST

Original text of this message