Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4B5759A3.3010701@mchambliss.com>
Date: Wed, 20 Jan 2010 12:29:39 -0700
From: Michael Chambliss <email@mchambliss.com>
User-Agent: Postbox 1.1.0 (Windows/20091201)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Oracle PL/SQL with Schema Migrations
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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