Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

result of string concatenation is too long

user12057782Mar 30 2012 — edited Mar 30 2012
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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2012
Added on Mar 30 2012
4 comments
2,982 views