This discussion is archived
9 Replies Latest reply: Jun 28, 2013 6:05 AM by Roger25 RSS

clob in Forms

Roger25 Explorer
Currently Being Moderated



If I have in the database a clob column which currently has 45000 characters, how can I handle this in Forms? I want a multiline text item (which, as per the Forms doc. is limited to 65534 characters), and to display that clob into my multiline text item. However, the dbms_lob.substr accepts only 32767 in the second parameter..

That's how I tried:


:block3.text_item5 := dbms_lob.substr(r.clob_data, 32767, 1);

But normally, it shows up only 32767 characters.




  • Correct Answers - 10 points
  • Helpful Answers - 5 points