Oracle PL/SQL declare, begin, end from Ant

Ant again. We had a file with Oracle PL/SQL statements using declare, begin and end. When using the sql task in Ant, it complained about reaching end-of-file on the line with “declare”. The problem is that Ant assumes that one line is one SQL statement, but it’s not that simple when using declare, begin and end. The solution is to set slash (‘/’) as a statement delimiter. The excellent blog article Executing Oracle PL/SQL from Ant describes the problem and solution in more depth.

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.