result of string concatenation is too long
Hi
when i am trying to insert data which is having more than 4000 characters i am getting below error.
**result of string concatenation is too long***.
is there any way to load the data in to clob column which is having more than 4000 characters?Please Help
Please find my code below.
create table tgt_table (sql_text clob);
Declare
l_var1 varchar2(4000):='hi.......'; --1000 characters
l_var2 varchar2(4000):='ram......'; ---2000 characters
l_var3 varchar2(4000):='india.......'; --3000 characters
l_var varchar2(4000);
begin
insert into tgt_table values(l_var1||l_var2||l_var3);
commit;
end;