Re: Sqlplus in Batch file.

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 Received on Fri Mar 07 2008 - 11:42:31 CST