I did the following and this worked great. Since I am running this from
a visual basic app I need to make sure the sqlplus window closes after
the script is complete. What would I need to do to terminate
(disconnect and exit) the process of the sqlplus.
Dennis Richter wrote:
>
> sqlplus with the -s option (silent mode) should do the trick.
>
> For example: sqlplus -s userid/password @script.sql
>
> If you do not want to pass userid and password on the command line, then
> include the /NOLOG parameter and issue the CONNECT from within the script
> file.
>
> Sally Madeira <softsense_at_home.com> wrote in message
> news:38B6FCED.31458D6_at_home.com...
> > Hello,
> >
> > I have sveral *.sql files that I need to run during a process that I am
> > writing in visual basic. I am using ADO and have not found anything
> > that is useful. These sql scripts are not short. One script creates 20
> > temporary tables! Is there a command line argument that I could kick
> > off from VB that could run the scripts.
> >
> > Thanks
> > Sally
Received on Sat Feb 26 2000 - 18:24:10 CST
