Re: Question; SQL Plus commands and NT Batch file.

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
> =-----
>
>

-----------== 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 =----- Received on Wed Sep 25 2002 - 17:05:06 CDT