And the code is like this:

<?xml version="1.0" encoding="UTF-8"?>
<project basedir="." name="Test" >
        <target name="Test">
                <sql
                        driver="oracle.jdbc.OracleDriver"
                        url="jdbc:oracle:thin:@server:1521:FCDEV"
                        userid="x"
                        password="x"
                        print="yes">
                        <classpath>
                                <pathelement location="ojdbc6.jar"/>
                        </classpath>
                        select ID from OPERATIONPLANHEADER
                </sql>

                <for list="???" delimeter="???" param="???">
                        <sequential>
                            ....
                        </sequential>
                </for>
        </target>
</project>

--
View this message in context: 
http://ant.1045680.n5.nabble.com/SQL-task-and-iterating-over-results-tp5017227p5017234.html
Sent from the Ant - Users mailing list archive at Nabble.com.

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

Reply via email to