Q: looping over exec task

[Bart van Kuik <ba...@oracle.com>]

Hi ppl,

I'm using Ant to run a SQL script, like this:

     <target name="sql">
         <fileset dir="sql" id="fs">
             <include name="*.sql"/>
         </fileset>
         <!-- Convert the names to a property -->
         <pathconvert pathsep=" " property="pks" refid="fs"/>

         <exec executable="sqlplus" dir="sql">
             <arg value="-S"/>        <!-- Silent -->
             <arg value="${db_login}/${db_passwd}@${db}"/>
             <arg value="${sql}"/>
         </exec>
     </target>

Problem is: sqlplus (the commandline Oracle client) doesn't accept 
multiple files! I want to work around this by looping over the exec 
task. Can this be done. A little googling showed some javascript 
kludges, but I want some clean XML, please :)

TIA
Bart


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