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

11/27/2019

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

slightwv (䄆 Netminder)

11/27/2019

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

awking00

11/27/2019

>>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?

srikotesh

11/27/2019

ASKER

thanks

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

Certified Expert Program

Credly Partnership

Udemy Partnership