Column oracle clob issue

[Spotmydot]

Hello,

With the update table tag, when specify column of type="CLOB" this isn't handled correctly by liquibase and throws error. ORA-01704: string literal too long.
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)

e.g:

<changeSet id="id_example" author="spotymydot" runOnChange="true">
    <update tableName="RULES">
        <column name="script" type="CLOB"><![CDATA[

lots of data goes here
]]>

This requires the oracle function to_clob() to be used.

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions182.htm

This is with the latest 3.2.0 version of liquibase

[Spotmydot]

Looks like this has fixed this in a fork by @leonardseymore
please pull this into master
liquibase/liquibase#257

[dcebotarenco]

Please push the fix to master. I have 3.2.2 and the fix is not applied.
current code:
UpdateDataChange.class
for (ColumnConfig column : getColumns()) {
if (column.getValueBlobFile() != null) {
needsPreparedStatement = true;
}
if (column.getValueClobFile() != null) {
needsPreparedStatement = true;
}
}

same in InsertDataChange.class
for (ColumnConfig column : columns) {
if (column.getValueBlobFile() != null) {
needsPreparedStatement = true;
}
if (column.getValueClobFile() != null) {
needsPreparedStatement = true;
}
// if (column.getValueText() != null && database instanceof InformixDatabase) {
// needsPreparedStatement = true;
// }
}

[nvoxland]

Merged in pull request liquibase/liquibase#257 for liquibase 3.3.0