db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Max Meier (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-225) Automatic datatype change LONG VARCHAR to CLOB lacks necessary cast, ORA-00997
Date Wed, 10 Sep 2008 15:22:44 GMT
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.


Mime
View raw message