I suppose the easies, though maybe not the smartest way to do it, would
be to use exec task. Of course that is only useful if you have a command
line interface for the db that You're trying to use. You could put this
in some *.sql file and have it exec-uted from ant. Does that help?
Best regards,
Krzysztof
temp temp wrote:
I trying to execute small script using ant , here is the script
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET MARKUP HTML OFF
SET ESCAPE \
SPOOL DELETEME.SQL
select 'drop table ', table_name, 'cascade constraints \;' from user_tables
how to run this script using ant sql task
Thanks
Miro
---------------------------------
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
and lay it on us.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
