ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Oracle PL/SQL with Schema Migrations
Date Wed, 20 Jan 2010 21:54:21 GMT
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 <email@mchambliss.com>wrote:

> 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 like this:
>
> DECLARE
>  sometime date;
> BEGIN
>  select sysdate into sometime from dual;
> END;
>
> would fail on line 2.  In a more realistic case, simply creating a function
> or trigger would trip things up.  Was this scenario later compensated for
> via environment configuration options, or has anyone found a good work
> around?
>
> Thanks!
> Mike
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message