Kbase P177007: BUFFER-COPY to Oracle table containing a CLOB field fails when CLOB data is empty/zero-length
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/03/2011 |
|
Status: Unverified
SYMPTOM(s):
BUFFER-COPY to Oracle table containing a CLOB field fails when CLOB data is empty/zero-length
Multiple errors occur when attempting the BUFFER-COPY
ORACLE error -24801 see "ORACLE Error Messages and Codes Manual". (1252)
** illegal parameter value in OCI lob function
Large object assign or copy failed. (11395)
Undo of sub-transaction modifying a large object. Backing out transaction. (11599)
A column in this row being inserted or updated is too large (4212)
SYSTEM ERROR: fdudel failed in bfundo dbkey=-8334. (1397)
Using ASSIGN within the BUFFER-COPY statement does not prevent the errors
Excluding the CLOB field from the BUFFER-COPY statement avoids the issue
FACT(s) (Environment):
No errors reported in the dataserv.lg file
OpenEdge 10.2x
All Supported Operating Systems
CAUSE:
Bug# OE00202696
FIX:
Option #1
Upgrade to 10.2B04 or later.
Option #2
Replace BUFFER-COPY with a standard ASSIGN statement.
It is possible to use built-in Data Administration functionality (Utilities > Generate Include Files > ASSIGN statement) to generate the ASSIGN statement rather than coding it from scratch (e.g. for large tables).