| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Question; SQL Plus commands and NT Batch file.
If the sql you inserted here is an exact copy then you may be missing a ";"
at the end of the insert. This would cause the sql processor to keep
waiting for commands until the ; is pressed. Try inserting a ; after the
last line of the insert then a blank line then the exit command and a blank
line. This should cause the sqlplus window to close.
Then at the bat file level you may need to have an exit at the end but possibly not.
Kevin
"Joe Caporina" <spam_at_nospam.com> wrote in message
news:3d921631$1_8_at_news.newsgroups.com...
> Thanks, I did that , but it did not work till someone recommended I skip a
> line before typing exit in my sql script.
> "Wells" <wshammou-NoSpam_at_optonline.net> wrote in message
> news:Jaak9.340$Wk.53150_at_news4.srv.hcvlny.cv.net...
> > I put "quit" at the end of my sql scripts. The batch file automatically
> > ends when the last command is executed, provided it regains control.
The
> > "quit" will exit SqlPlus and return control to the batch file.
> >
> > Cheers,
> > Wells...
> >
> > "Joe Caporina" <spam_at_nospam.com> wrote in message
> > news:3d90e127$1_7_at_news.newsgroups.com...
> > > I'm sure someone seen this before and knows the answere. I created a
> > > scheduled NT batch file to run a SQL Loader and SQL script to update
my
> > > Cisco Radius logs into an Oracle database table for an account billing
> > > front end. The Question is how do I get the SQL Plus script to exit
and
> > > close the DOS window when the .bat is executed and finished. Exit does
> > work
> > > without the enter key.
> > > Copy of batch file ;
> > > sqlldr Telecomm/Password_at_pmgd.es.alliance.com
> > > control=e:\radius\sqlldr\loader.ctl log=log23 skip=1
> > > data=e:\radius\sqlldr\iasdata.csv
> > >
> > >
> > > sqlplus Telecomm/Password_at_pmgd.es.alliance.com
@e:\radius\sqlldr\insert
> > >
> > > Copy of SQL script ;
> > > create ias_records2 as select distinct * from ias_records
> > >
> > > drop ias_records
> > >
> > > rename ias_records2 to ias_records
> > >
> > > insert into telecomm.accttable
> > >
> > >
> >
>
(username,duration,nasaddress,nasport,bytesin,bytesout,paksin,paksout,framed
> > >
> >
>
ipaddress,nasidentifier,acctlinkcount,connectinfo,shivatypeofservice,calling
> > >
> >
>
stationid,calledstationid,shivadisconnectreason,logoutdatetime,logindatetime
> > > )
> > >
> > > select
> > >
> > >
> >
>
user_name,acct_session_time,nas_ip_address,nas_port,acct_input_octets,acct_o
> > >
> >
>
utput_octets,acct_input_packets,acct_output_packets,framed_ip_address,nas_id
> > >
> >
>
entifier,acct_link_count,connect_info,service_type,calling_station_id,called
> > > _station_id,acct_terminate_cause,ias_logoutdatetime,ias_logindatetime
> > >
> > > from telecomm.ias_records
> > >
> > > exit
> > >
> > >
> > >
> > >
> > >
> > > -----------== Posted via Newsfeed.Com - Uncensored Usenet News
> > ==----------
> > > http://www.newsfeed.com The #1 Newsgroup Service in the
World!
> > > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
> > =-----
> >
> >
> > > >
 |
 |