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

    clob in Forms




      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.