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?