ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bart van Kuik <>
Subject Re: AW: Running SQL Scripts from <exec>
Date Thu, 12 Jun 2003 11:08:06 GMT
I did this and it works fine. But there is one problem: I want to run 
multiple scripts from a directory. I thought I could solve this by using 

     <target name="util">
         <!-- Run all package specifications -->
         <apply executable="sqlplus">
             <arg value="-S"/>
             <arg value="${db_login}/${db_passwd}@${db}"/>
             <fileset dir="source">
                 <include name="**/*.pks"/>

BUT... the problem is that sqlplus has the following syntax:
sqlplus user/passwd@database @script.sql

See the at-symbol in front of the script name? I can't get this to work.

Any ideas from this list?

Bart wrote:
> If you really want to use Oracles sqlplus why not using that as executable?
> But without knowing sqlplus, I think you should use <arg line/> instead of
> <arg value/>,
> because e.g. "imp USERID=... FROMUSER..." is _one_ value and I think sqlplus
> wants several
> values. I suggest using mutliple <arg> lines for better reading:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message