[jira] Created: (DDLUTILS-225) Automatic datatype change LONG VARCHAR to CLOB lacks necessary cast, ORA-00997

[Max Meier (JIRA)]

Automatic datatype change LONG VARCHAR to CLOB lacks necessary cast, ORA-00997
------------------------------------------------------------------------------

                 Key: DDLUTILS-225
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-225
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - Oracle
    Affects Versions: 1.0
         Environment: Oracle 9.2.0.1
J2SE 1.5
            Reporter: Max Meier
            Assignee: Thomas Dudziak


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.




-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.