Oracle and CLOBs: string literal too long
Posted on 2001-08-09
We're currently writing a VB app that uses Oracle in the backend.
And, in attempting to insert data into a table with a CLOB column, we're getting the following error:
ORA-01704 string literal too long
Now, I understand that there is a 2000 character limitation when using a straight INSERT pass-through statement. But, what are the other options?
Unfortunately, we cannot use stored procedures, and we cannot use OO4O (strictly ADO).
How does this affect me on UPDATES, also?