Nclob - nVarchar
Having a problem with nVarchar2 and the max length of a row. We need to extend it to 3600, now it is set as 4000 but it can not be inserted more than 2000 chars. Char_length 2000.
So, then i tried nClob but max length was 2480.
declare
v_var nclob;
begin
v_var := 'XXXXXXX 2480 times ... '
insert into aka_c values (v_var);
commit;
end;
/
But i feel like it should be possible to have a larger string to insert... We need this nClob (NLS) because of the worldwide application.
What do i have to do?
/A