Link to home
Start Free TrialLog in
Avatar of srikotesh
srikotesh

asked on

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.
Avatar of sarabande
sarabande
Flag of Luxembourg image

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
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>I have copied this clob value from the existing record of a table<<
What are the data types of the existing and the column you want to insert? What was the command you tried?
Avatar of srikotesh
srikotesh

ASKER

thanks