Only the following statement worked rather than straight query or stored procedure for me for storing string that has 4000 and more characters. But why ?
declare tempVal varchar2(32767) := 'long string'; begin update FMS_K_OFFICEWISE_LETTER set FKOL_LETTER_BODY=tempVal where FKOL_OFFICEWISE_LETTER_ID=60; end;
Is it always we should do for storing string of 4000 characters and more ?
The data type of FMS_K_OFFICEWISE_LETTER is actually in CLOB.