ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antoine Levy-Lambert <antoinelev...@yahoo.com>
Subject Re: Running SQL Scripts from <exec>
Date Wed, 11 Jun 2003 16:13:26 GMT
Paul, there is a sql task, that might be better than
exec.
Yours
Antoine
----- Original Message ----- 
From: "Beccio, Paul" <Paul.Beccio@baesystems.com>
To: "'Ant Users List'" <user@ant.apache.org>
Sent: Wednesday, June 11, 2003 6:07 PM
Subject: Running SQL Scripts from <exec>


> I'm writing a nightly data push with Ant and I'm
stuck. If I wanted to run a
> sql script from an exec file for an oracle push, can
i just use the exec to
> run an external sql file? How do I define where that
sql file would reside
> so Ant can find it? 
> 
> Something like:
> 
> <exec executable="cmd.exe">
>    <arg value="d:\oracle\ora81\bin\sqlplus.exe"/>
> <!-- Would like to run an external sql script -->
>    <arg value="thisuser/gouser@intranet_db
@d:\sql_stuff.sql >
> d:\staging\log.log"/>
>    <arg value="imp USERID=systemm/myuser@intranet_db
FROMUSER=thisuser
> TOUSER=newuser TABLES=my_table IGNORE=y
FILE=d:\dump.dmp"/>
> </exec>
> 
> Thanks!
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
user-unsubscribe@ant.apache.org
> For additional commands, e-mail:
user-help@ant.apache.org
> 
> 

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message