Re: CLOB to VARCHAR2 -- (ver 9i)

On 18 Sep 2006 10:46:22 -0700, matt_at_mailinator.com wrote:

>
>Sybrand Bakker wrote:
>> did you try? As far as I know it is possible.
>> Just assign it. Implicit conversion shouldn't be a problem.
>
>yep, i had tried it before posting. it throws an ORA-22859 exception:
>
> http://ora-22859.ora-code.com
>
>Cause: An attempt was made to modify an object, REF, VARRAY, nested
>table, or LOB column type.
>
>Action: Create a new column of the desired type and copy the current
>column data to the new type using the appropriate type constructor.
>
>
>...a CLOB is a LOB, so i dont think it can be done. according to the
>above, one must copy the LOB column's data to the new column.
>
>
>matt

http://asktom.oracle.com/pls/ask/f?p=4950:8:13266295515100393693::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:18909757644296

Please *ALWAYS* post your version in ordet to get *accurate* answers and not waste peoples time.

Oracle 8i, BTW, is desupported for more than a year.

--
Sybrand Bakker, Senior Oracle DBA