[DDLUTILS-225] Automatic datatype change LONG VARCHAR to CLOB lacks necessary cast, ORA-00997

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0
• Fix Version/s: 1.1
• Component/s: Core - Oracle
• Environment: Oracle 9.2.0.1; J2SE 1.5
• Assignee: Thomas Dudziak
• Reporter: Max Meier
• Created: 10/Sep/08 15:21
• Updated: 03/Nov/08 23:54

Description

I try reading a database model, which contains a table with LONG VARCHAR columns in it. As described in the documentation, the write-back of the unchanged model to Oracle results in a ColumnDataTypeChange (to CLOB).
When the change is to be applied to the DB, there is no cast from LONG VARCHAR to LOB. Say I have a table

CREATE TABLE T (
DATA LONG VARCHAR
);

the script, which is generated by ddlutils is

CREATE TABLE T_ (
DATA CLOB
);

INSERT INTO T_ (DATA) SELECT DATA FROM T;

[...]

At this point Oracle exits with ORA-00997: Unzulässige Verwendung des Datentyps LONG

IMHO the script should have been

INSERT INTO T_ (DATA) SELECT TO_LOB(DATA) FROM T;

which works fine.