Re: Program interacting with SQL*Plus
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 01 Jul 2002 15:15:42 GMT
Message-ID: <3D2071FC.C185E9_at_exesolutions.com>
Date: Mon, 01 Jul 2002 15:15:42 GMT
Message-ID: <3D2071FC.C185E9_at_exesolutions.com>
David Van Horn wrote:
> 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
Why did you decide to take this approach? What is the driver running the shell script?
I've seen this approach used many times. And it is never as stable, as efficient, or as manageable as using DBMS_JOB and going the other direction when-ever possible.
Daniel Morgan Received on Mon Jul 01 2002 - 17:15:42 CEST