DevOps, CI/CD and Automation

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!

Inserting data into CLOB fields

302285Jul 8 2002

I am trying to insert a 100,000+ byte string into a CLOB field in Oracle, but getting a "string literal too long" error. I am using Visual Basic and ADO to try to accomplish this. My insert statement is:

sql = "INSERT INTO IMAGE_VERSION " & _
"(field1, field2, field3)" & _
"VALUES('" & strNm & "', '" & strDt & "', '" & strData & "')"

Field 3 is defined as a CLOB in the database. From what I understand, the CLOB can hold massive amounts of data.

Can anyone lend a hand?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2002

Added on Jul 8 2002

#odbc, #windows-and-net

3 comments

1,143 views