9 Replies Latest reply: Jun 28, 2013 8:05 AM by Roger25 RSS

    clob in Forms

    Roger25

      Hi,

       

      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.

       

      Thanks.