ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Beccio, Paul" <Paul.Bec...@baesystems.com>
Subject Running SQL Scripts from <exec>
Date Wed, 11 Jun 2003 16:07:18 GMT
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


Mime
View raw message