Showing results for 
Search instead for 
Did you mean: 

CLOB to Varchar

0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

hi friend

CLOB(Character large object),it is used to store large blocks of single bite character data in database

that's y change object properties to lang text


Former Member
0 Kudos

Hi Pali,

In your object properties, try changing the type from character to Long Text. It should parse correctly and without error, and work as you expect it to.

Let me know if it works.