Re: create CSV with CLOB

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 07 Oct 2002 23:01:29 GMT
Message-ID: <3DA2122A.C398671C@exesolutions.com>

zeb wrote:

> Hi,
>
> I want to create a CSV file from a table where a column is a CLOB
> 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 ?
>
> Thanks in advance
>
> Oracle 8.1.7
> HP-UX 11.0

Extract it in 32K bites using DBMS_LOB if you are doing what I think you are doing.

Daniel Morgan Received on Mon Oct 07 2002 - 18:01:29 CDT