[
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.
