Insufficient Character Length for Oracle Reports 6i
hi,
In my Oracle Report, I have used a formula column to extract the clob data which I have converted to varchar2 by using the dbms_lob.substr.
However, my clob data is around 13812 and when I ran the report, I got the generic signal 11 error.
Just to be sure that it was my clob data causing this signal 11 error, I have substr-inged my clob data to 8191 (I started from 4000 and worked my way up to 8191) and it is not giving me this signal 11 error anymore.
My problem is, I really need to display the entire clob data and not just some portion of it.
In my Oracle Report, I have used a formula column to extract the clob data which I have converted to varchar2 by using the dbms_lob.substr.
However, my clob data is around 13812 and when I ran the report, I got the generic signal 11 error.
Just to be sure that it was my clob data causing this signal 11 error, I have substr-inged my clob data to 8191 (I started from 4000 and worked my way up to 8191) and it is not giving me this signal 11 error anymore.
My problem is, I really need to display the entire clob data and not just some portion of it.
0