Kbase P90349: Error 11209 when trying to insert a CLOB / LVARCHAR field.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/19/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A
SYMPTOM(s):
Error 11209 when trying to insert a CLOB / LVARCHAR field.
Inserting a CLOB field via JDBC.
[JDBC OpenEdge Driver]:Long data exceeds column width. (11209)
CAUSE:
You are trying to insert a string which is longer than the defined length for the CLOB field. By default the length is 32k.
FIX:
When creating a table which contains a CLOB field, make sure you define the proper length for the CLOB field, e.g. to define a 1MB CLOB field:
CREATE TABLE tbl (
ID varchar (50) NOT NULL,
XML clob (1048576),
PRIMARY KEY (ID)
)