Home -> Usenet -> comp.databases.oracle -> Using VB to control isqlplus/sql scripts

Using VB to control isqlplus/sql scripts

From: Pike <voidrubbish_at_hotmail.com>
Date: 12 Sep 2002 14:10:48 -0700
Message-ID: <8e8fa11e.0209121310.3b26bed4_at_posting.google.com> 






Hi,



I know this probably has an obvious answer, but I've searched the web
for over an hour and can't find it.  The problem goes...



In isqlplus I have a script which I run with something like



_at_file.sql



or



start file.sql



where file.sql contains numerous sql statments, and spools comments to
a log file.



How would I automate this process in VB?  I won't be able to use a
standard ADODB.Connection object as that won't do the log file
spooling.



Thanks!




Pike
Received on Thu Sep 12 2002 - 23:10:48 CEST












Original text of this message