var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: character string buffer too small
I’m running into a problem when I try to convert some of our clob fields to character strings to display on a Powebuilder report. I’m using the function dbms_lob to convert, as in:
Select dbms_lob.substr(d.notes,32767,1) from myreport d
32,767 is the maximum string size this function can handle, and the sql statement is crashing with a “character string buffer too small” error when it encounters a really big report.
How can I get around this?