more than 32678 bytes clob DBMS_LOB.GETLENGTH return null

can not input into clob

solution
use utl_file, generate and input


 Go to Tools => Preferences from the menu.
Then click 'Output' (on the left side, in the 'Oracle' menu), and see if the 'Enabled' checkbox is checked or not...


lncount:= CEIL(DBMS_LOB.GETLENGTH(icJournaldetail)/256);


declare this

lcStr     clob := icJournaldetail;