Re: Converting LONGs to NCLOBs

From: Gary Fowler <grfowler_at_mmm.com>
Date: Wed, 11 Oct 2000 13:11:54 -0600
Message-ID: <39E4BB79.2B9CAC2A@mmm.com>

The answer that I found from Oracle was that it is not possible to convert a LONG to an NCLOB using the TO_LOB() function. The documentation is in error.

Gary Fowler wrote:

> I have a table in Oracle 8i that has a LONG column.
> I want to convert the column to an NCLOB. The
> documentation shows how to convert a LONG to a
> CLOB, and it implies that you can do the same for
> and NCLOB. However, if I try to do it with an
> NCLOB column I get the error:
>
> ORA-00932: inconsistent datatypes
>
> If anyone has any experience with this that they would
> like to share, I would love to hear it. Right now I'm
> stumped.
>
> Thanks,
> Gary Fowler
> 3M Health Information Systems
> grfowler_at_mmm.com
Received on Wed Oct 11 2000 - 14:11:54 CDT