Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Exclamation Unanswered: character string buffer too small

    Im running into a problem when I try to convert some of our clob fields to character strings to display on a Powebuilder report. Im 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 retrieves a really big report from my Oracle database.
    Is there a way to display my data from Oracle clob column which I converted to string in my stored procedure so it can display on my PB report without crashing my system?

    How can I get around this?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts