# Getting Issue when Liquibase trying to execute Oracle query

**URL:** <https://forum.liquibase.org/t/getting-issue-when-liquibase-trying-to-execute-oracle-query/1908>\
**Category:** General Discussion\
**Created:** [April 9, 2012, 9:19pm UTC](https://forum.liquibase.org/t/getting-issue-when-liquibase-trying-to-execute-oracle-query/1908 "2012-04-09T21:19:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [April 9, 2012, 9:19pm UTC](https://forum.liquibase.org/t/getting-issue-when-liquibase-trying-to-execute-oracle-query/1908/1 "2012-04-09T21:19:00Z")

</div>

Hi Team,  
  
Our application having following technologies,  
Grails 1.3.7, Oracle XE, Database-migration-1.0 plugin and Liquibase 2.0.1.  
In this application we are using Database-migration-1.0 plugin which uses Liquibase 2.0.1 library to manage DB changes.  
  
Here DB changes are done in separate changelog files(eg., r18-base.groovy, r18-to-r19-baseline.groovy, R19-add-contractToSite.groovy) and these files are incorporated into a root file(changelog.groovy).  
  
When we are updating the DB using grails dbm-update command, Liquibase trying to execute queries in the change log files.  
  
There we are getting the error as,  
  
&nbsp;  
  
2012-04-09 16:03:45,939 [main] ERROR liquibase&nbsp; - Change Set r18-base.groovy::1332771601628-1::asidua (generated) failed.  
  
Error: Error executing SQL CREATE TABLE ADMINISTRATION (ID VARCHAR2(255 BYTE) NOT NULL, VERSION NUMBER(19,0) NOT NULL, NAME VARCHAR2(255 BYTE) NOT NULL, “VALUE” VARCHAR2(255 BYTE) NOT NULL, CONSTRAINT SYS\_C0090814 PRIMARY KEY (ID)):  
  
Wrong data type: VARCHAR2 in statement [CREATE TABLE ADMINISTRATION (ID VARCHAR2]  
  
&nbsp;  
  
liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE ADMINISTRATION (ID VARCHAR2(255 BYTE) NOT NULL, VERSION NUMBER(19,0) NOT NULL, NAME VARCHAR2(255 BYTE) NOT NULL, “VALUE” VARCHAR2(255 BYTE) NOT NULL, CONSTRAINT SYS\_C0090814 PRIMARY KEY (ID)):  
  
Wrong data type: VARCHAR2 in statement [CREATE TABLE ADMINISTRATION (ID VARCHAR2]  
  
&nbsp;  
Could you please clarify this issue?  
  
Regards,  
Raja

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [April 9, 2012, 9:19pm UTC](https://forum.liquibase.org/t/getting-issue-when-liquibase-trying-to-execute-oracle-query/1908/2 "2012-04-09T21:19:00Z")

</div>

The sql seems right for oracle off hand. Do you get a more helpful error message if you run the sql through an oracle sql tool?

\<span VARCHAR2(255 BYTE) NOT NULL, CONSTRAINT SYS\_C0090814 PRIMARY KEY (ID))

Nathan