getting string literal is too long while inserting clob data in table
Hi Experts,
I trying insert a record in a table.
table having clob value for one column.
I have copied this clob value from the existing record of a table.
same clob value trying to insert
I am getting the error string literal is too long
how to resolve.
I trying insert a record in a table.
table having clob value for one column.
I have copied this clob value from the existing record of a table.
same clob value trying to insert
I am getting the error string literal is too long
how to resolve.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
you can't do it with a literal as part of the sql statement but use a bind variable instead. bind your parameter correctly for long data, for example SQL_LONGVARCHAR and not SQL_VARCHAR.
Sara
Sara
For one-time things, I use a PL/SQL block. You just need to break up the value into smaller chunks less than 4000 characters.
Something like this:
Something like this:
declare
myClob clob;
begin
myClob := myClob || 'Hello';
myClob := myClob || ' World';
insert into myTable values(myClob);
end;
/
Premium Content
You need an Expert Office subscription to comment.Start Free Trial