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.