ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Beccio, Paul" <Paul.Bec...@baesystems.com>
Subject RE: Running SQL Scripts from <exec>
Date Thu, 12 Jun 2003 13:40:16 GMT
Thanks Bart/Jan,

That definitely consolidates the process... and in this case more args the
better too.

-----Original Message-----
From: Bart van Kuik [mailto:bart.van.kuik@oracle.com]
Sent: Thursday, June 12, 2003 7:11 AM
To: Ant Users List
Subject: Re: Running SQL Scripts from <exec>


Paul, use Jan's suggestion, I tried it and it works. However, if you 
just want to execute one command (for instance do unit testing using 
utplsql) I've done the following:

     <target name="test">
         <tempfile property="sql_script" suffix=".sql"/>
         <echo file="${sql_script}">
             exec utplsql.testsuite('ew', false);
             exit;
         </echo>
         <exec executable="sqlplus">
             <arg value="-S"/>
             <arg value="${db_login}/${db_passwd}@${db}"/>
             <arg value="@${sql_script}"/>
         </exec>
         <delete file="${sql_script}"/>
     </target>


Beccio, Paul wrote:
> 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? 


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

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


Mime
View raw message