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.
Oracle Database
Last Comment
srikotesh
8/22/2022 - Mon
sarabande
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.
>>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?
Sara