File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sqlplus

 
Macca Murray
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Sheriff
Posts: 11962
5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Would it be an option to call sqlplus using the <exec/> task?
 
Macca Murray
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i dont know havent really tried it, ill give it ago and let you know, thanks for the idea
 
Macca Murray
Greenhorn
Posts: 9
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this is what i have



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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic