Is it always we have to take help of PL/SQL for storing string having 4000 and more characters in oracle?

Question

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.

Answer 1

Why not declare it as a CLOB, or better yet as:

FMS_K_OFFICEWISE_LETTER.FKOL_LETTER_BODY%Type;