# modifyDataType change set does not terminate the sql statement properly

**URL:** <https://forum.liquibase.org/t/modifydatatype-change-set-does-not-terminate-the-sql-statement-properly/368>\
**Category:** General Discussion\
**Created:** [December 2, 2009, 4:04am UTC](https://forum.liquibase.org/t/modifydatatype-change-set-does-not-terminate-the-sql-statement-properly/368 "2009-12-02T04:04:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ionalumoraru](https://avatars.discourse-cdn.com/v4/letter/i/3e96dc/32.png) [@ionalumoraru](https://forum.liquibase.org/u/ionalumoraru)\
**Post date:** [December 2, 2009, 4:04am UTC](https://forum.liquibase.org/t/modifydatatype-change-set-does-not-terminate-the-sql-statement-properly/368/1 "2009-12-02T04:04:00Z")

</div>

The following change set:

generates this error:  
&nbsp; &nbsp; [java] liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE CARDCATALOG MODIFY ( LABEL VARCHAR2(64)

Running 2.0 RC1 on Oracle.  
Ion

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [December 2, 2009, 4:04am UTC](https://forum.liquibase.org/t/modifydatatype-change-set-does-not-terminate-the-sql-statement-properly/368/2 "2009-12-02T04:04:00Z")

</div>

It has been fixed since RC1.&nbsp; You can get the latest build from [http://www.liquibase.org/ci/latest&nbsp;](http://www.liquibase.org/ci/latest%C2%A0) It should fix the problem.

Nathan

---

<div class="post-metadata">

**Author:** ![ionalumoraru](https://avatars.discourse-cdn.com/v4/letter/i/3e96dc/32.png) [@ionalumoraru](https://forum.liquibase.org/u/ionalumoraru)\
**Post date:** [December 2, 2009, 4:04am UTC](https://forum.liquibase.org/t/modifydatatype-change-set-does-not-terminate-the-sql-statement-properly/368/3 "2009-12-02T04:04:00Z")

</div>

Thanks Nathan.

Works fine in 2.0 RC2.

Ion

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [December 2, 2009, 4:04am UTC](https://forum.liquibase.org/t/modifydatatype-change-set-does-not-terminate-the-sql-statement-properly/368/4 "2009-12-02T04:04:00Z")

</div>

Great, thanks for testing it out.

Nathan