Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Running an SQL File - help

Re: Running an SQL File - help

From: Niall <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 29 Feb 2000 09:26:54 -0000
Message-ID: <89g3c3$9me$1@soap.pipex.net>


put exit after the script ends

so a script might read

create table test(test1 varchar2(20)
/
exit

HTH "Sally Madeira" <softsense_at_home.com> wrote in message news:38B8702E.8BEACDF1_at_home.com...
> 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 Tue Feb 29 2000 - 03:26:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US