Re: Sqlplus in Batch file.
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Mar 2008 09:37:04 -0800
Message-ID: <1204911423.145918@bubbleator.drizzle.com>
Date: Fri, 07 Mar 2008 09:37:04 -0800
Message-ID: <1204911423.145918@bubbleator.drizzle.com>
PowerOne 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?
You wrote: "I need to ...."
What are you going to do if you can't do that?
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Mar 07 2008 - 11:37:04 CST