Re: concat LONG

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 1 Oct 2002 01:09:21 -0700
Message-ID: <a20d28ee.0210010009.4bdf1a9b@posting.google.com>

"zeb" <thierry.constant1_at_free.fr> wrote in message news:<3d98abf3$0$568$626a54ce_at_news.free.fr>...
> Hi,
>
> I want to create a CSV file from a table where a column is a LONG
> so I use concatenation , I have the following error:
>
> select exp||';'||bresoc||';'||';'||resume||';'||coddos from table_name
>
> *
> ERROR at line 1:
> ORA-00932: inconsistent datatypes
>
> How can I do that ?
> My LONG column can be truncate ( the data are not so long ... )
>
>
> Thanks in advance
>
> Oracle 8.1.7
> HP-UX 11.0

Please refer to the documentation for the restrictions of the (obsolete, available for downwards compatibility only) LONG datatype, and decide to stop using it. This is one of the restrictions. CLOBs don't have them.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 01 2002 - 03:09:21 CDT