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.