I have a clob column that has rows that have almost 6K character in them. There are duplicate rows in the data that I'm trying to remove using the distinct in my select.
I keep getting a "inconsistent datatypes: expected - got CLOB 00932. 00000 - "inconsistent datatypes: expected %s got %s"
This is my very basic query
select distinct detail from News a left join category b on a.id = b.id
There are more columns i'm going to add to this query that is why the left join is there. I wanted to get the clob figured out first.
I have tried
select distinct dbms_lob.substr( detail, 6000, 1 ) from news
but get an error
numeric or value error: character string buffer too small
Any help would be greatly appreciated