sqlplus

[Macca Murray]

I am using ant, and the sql task, i was wondering if anyone knew how to use the sqlplus script I have with the ant sql task?

at them moment it doesnt like the @ command which sqlplus uses to call other sql scripts, i know that you can manually call multiple scripts with the transaction tag, however, i have a butt load of scripts to run and it would be optimum to call them all from one script

please help, this is killing me

Thanks!

[Lasse Koskela]

Would it be an option to call sqlplus using the <exec/> task?

[Macca Murray]

i dont know havent really tried it, ill give it ago and let you know, thanks for the idea

[Macca Murray]

this is what i have

<exec dir="${des.home}/${projectPath.home3}/SQL/" executable="sqlplus"">
    <arg line="ppitrgusr/ppitrgusr@ctpdev @build.sql"/>
</exec>

but i dont think it is working, it looks like it works, but all it does is:

[exec] Connected to:
[exec] Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
[exec] With the Partitioning, OLAP and Oracle Data Mining options
[exec] JServer Release 9.2.0.4.0 - Production

[exec] 104 Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
[exec] With the Partitioning, OLAP and Oracle Data Mining options
[exec] JServer Release 9.2.0.4.0 - Production

so it connects, then disconnects strait away, any ideas?