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

From: <matt_at_mailinator.com>
Date: 18 Sep 2006 09:27:41 -0700
Message-ID: <1158596861.539006.169080@m7g2000cwm.googlegroups.com>

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 Received on Mon Sep 18 2006 - 11:27:41 CDT