Re: SELECT DISCINT and CLOB -- can this be done (v9)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 18 Sep 2006 19:33:06 +0200
Message-ID: <a0mtg2di679gk8b4lq9gsr8flskkcp6eha@4ax.com>

On 18 Sep 2006 09:27:41 -0700, matt_at_mailinator.com wrote:

>hello,
>
>i have a table w/ a "Notes" column of CLOB datatype. on this table i am
>attempting to do a SELECT DISCINT which includes this column, but it
>generates the following error:
>
> "ORA-00932: inconsistent datatypes: expected - got CLOB"
>
>...ive done some research, and i see other Oracle 9 folks w/ this
>error. some of them allieviated it by using a different driver, which i
>cannot do. ive also seen a suggestion to wrap the CLOB column in a
>TO_CHAR() function, but that doesnt work for me.
>
>does anyone know if there is indeed a problem w/ what im trying to do?
>your comments are appreciated.
>
>
>thanks,
>matt

Please specify your environment. Oracle version up to five digits, and driver, up to five digits, as you don't seem to use the ordinary Oracle client.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Sep 18 2006 - 12:33:06 CDT