Hi,
I am using Oracle SQL Developer 1.5.5.
I am querying a description column (TERM_DESCRIPTION) from Informatica Business Glossary View MRX_BG_TERM and i came across ORA-22835. Here is the screenshot

This column has datatype as VARCHAR2(4000). But it appears to be oracle is considering this as CLOB and suggested the action items.
- Still I went ahead and tried actions it listed (using Substr, dbms_lob.substr ) but none of them worked
- Tried looking for maximum length, it has thrown the same error ORA-22835
- I also tried casting field (TERM_DESCRIPTION) as LONG CHAR(5000), this time it has thrown a different error ORA-00600
Can anyone please help me with the way to read the description column.
Thanks,
Shravan