ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Chambliss <em...@mchambliss.com>
Subject Oracle PL/SQL with Schema Migrations
Date Wed, 20 Jan 2010 19:29:39 GMT
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