Oracle Data Type: NCLOB - Receive SQL error when specifying NCLOB size

Description

NOTE: Also happens with BFILE, ROWID

Create table like so:

CREATE TABLE TESTNCLOB( NCLOB_NULL NCLOB NULL, NCLOB_NOTNULL NCLOB NOT NULL);

Take snapshot and notice the size is specified:

<changeSet author="robert" id="1382988693362-7">
<createTable tableName="TESTNCLOB">
<column name="NCLOB_NULL" type="NCLOB(4000)"/>
<column name="NCLOB_NOTNULL" type="NCLOB(4000)">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>

When attempting to run this, get a SQL error. Removing the (4000) fixes the problem.

Migration failed for change set Changelog/changelog.xml::1382988622897-7::robert: Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATATYPETEST.TESTNCLOB (NCLOB_NULL NCLOB(4000), NCLOB_NOTNULL NCLOB(4000) NOT NULL): ORA-00907: missing right parenthesis

Environment

Windows 8, Oracle

Status

Reporter

Kevin Chappell

Fix versions

Affects versions

Priority

Major
Configure