Re: Oracle PL/SQL with Schema Migrations

2010-01-20 Thread Michael Chambliss
Thanks, Clinton. That does work, with a few potential problems. In order for the DDL to execute properly with a full_line_delimiter set, you have to remove the semicolons at the end of single statement blocks (IE, create, insert, alter, etc). If the tool you used to generate the bootstrap DD

Re: Oracle PL/SQL with Schema Migrations

2010-01-20 Thread Clinton Begin
You can configure the line terminator in the environment properties. Try a full line delimiter like "GO" On Wed, Jan 20, 2010 at 12:29 PM, Michael Chambliss wrote: > Hello, > > I just wanted to follow up on a question that was asked back in October: > > http://www.mail-archive.com/user-java@ibat

Oracle PL/SQL with Schema Migrations

2010-01-20 Thread Michael Chambliss
Hello, I just wanted to follow up on a question that was asked back in October: http://www.mail-archive.com/user-java@ibatis.apache.org/msg14957.html In summary, PL/SQL terminates lines with a semicolon, which causes problems for the line delimiter logic in the migrations tool. Something lik