Can anyone tell me why i got the following error:

ORA-00932: inconsistent datatypes: expected - got CLOB

when i try to do a

Select Distinct(id), text
From paragraphs
where id IN
(select paragraph_id
from menuitems
where section_id = 10);

Is there some way to return the CLOB field with distinct IDs?