Since we generally deal with Oracle as soon as we got the tables created via an ant script we ran into problems with the procedures. The ant transaction which takes in a file assumes that every line is to be executed separately . This makes it difficult to compile procedures. However the sql task provides for that as well.
<sql driver=”oracle.jdbc.driver.OracleDriver” url=”url” userid=”username” password=”password” delimiter=”/” delimitertype=”row” keepformat=”yes”>