Re: Sqlplus in Batch file.

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Mon, 10 Mar 2008 01:51:56 GMT
Message-ID: <0v0Bj.22570$R84.1324@newssvr25.news.prodigy.net>

fitzjarrell_at_cox.net wrote:
> On Mar 7, 11:01 am, PowerOne <salazar.wi..._at_gmail.com> wrote:

>> Hi,
>>
>> I need a batch file to lunch sqlplus and run a statement but the login
>> must be in .par file like this:
>>
>> sqlplus @c:\mylogin.par  START @c:\mystatement.sql
>> exit
>>
>> when I run this .bat file in CMD prompt it open a new CMD logged in
>> Sqlplus but it does not the Statement specified.
>> What I'm doing wrong?

>
> Much.
>
> You'll need to rewrite your .bat and your .par files to look like
> these examples.
>
> .BAT file:
>
> sqlplus /nolog @mylogin.par
>
> mylogin.par:
>
> connect user/pass_at_server
> @c:\mystatement
>
> c:\mystatement.sql:
> <query here>
>
> exit -- To exit SQL*Plus and terminate the session
>
> Once you have this done you should see success:
>
> c:\>run_sqlplus_script
>
> c:\>sqlplus /nolog @myconn.par
>
> SQL*Plus: Release 10.2.0.3.0 - Production on Fri Mar 7 11:38:28 2008
>
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
>
> Connected.
>
> <query output here>
>
> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 -
> 64bit Production
> With the Partitioning option
> JServer Release 8.1.7.4.0 - 64bit Production
>
> c:\
>
>
> David Fitzjarrell

using a 10.2.0.3 client connecting to an 8.1.7.4 db? A bit old -- and unsupported? :) Received on Sun Mar 09 2008 - 20:51:56 CDT