CLOB to Varchar

Hello Everyone,

abc.HISTORY is a CLOB object in database. when this object used in webi used to give me an error.

So i used ...

dbms_lob.substr( abc.HISTORY, 8000, 1 ) .This does not work in all reports....

i get the below error

ORA-06502:PL/SQL: numaric or value error : character string buffer too small

reducing the length fixes the error but it breaks the text content.

is there any way i can covert this CLOB to VArchar or any other solution for this?

Thanks a Lot.