Java Mailing List Archive

http://www.ant-tasks.com/

Apache Ant Archive

» Ant Users List
» Ant Developers List
Invoking sql files in ANT.

Invoking sql files in ANT.

2007-07-19       - By Chun Ji
Reply:     1     2     3     4  


Hi all,
I  was trying to call some sql files from ANT, and it keeps giving me some "ORA
-00922, ORA-00900.." errors. I don't think there is anything special in the ant
/build.xml, but is because something in the sql file that ANT/SQL can not
recognize, such as:
"
set define off
...

spool exe_migration.sql
...

spool off

spool exe_migration.lst
@(protected)
spool off

". But on the other hand, the above sql runs errorless by using SQLPLUS.

So I am just wondering what is the limitation when sql files are invoked by ANT
? And if there is a way I can make the above sql working in ANT?


thanks.


Charlie
(The jdbc library I am using is: ojdbc14.jar, and ANT version is 1.7.0.
Everything is running on Linux box )



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@(protected)
For additional commands, e-mail: user-help@(protected)


©2008 ant-tasks.com - Jax Systems, LLC, U.S.A.