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

["Thomas Dudziak (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DDLUTILS-225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Dudziak updated DDLUTILS-225:
------------------------------------

    Fix Version/s: 1.1

> 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
>             Fix For: 1.1
>
>
> 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.