concat LONG

From: zeb <thierry.constant1_at_free.fr>
Date: Mon, 30 Sep 2002 21:59:02 +0200
Message-ID: <3d98abf3$0$568$626a54ce@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 Received on Mon Sep 30 2002 - 14:59:02 CDT