Kbase P185738: Getting error 10885 performing Update/Add table definition when working with Oracle through DataServ
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/04/2011 |
|
Status: Unverified
SYMPTOM(s):
Getting error 10885 performing Update/Add table definition when working with Oracle through DataServer connection.
No error generated when performing Schema Migration using OpenEdge DB to Oracle schema migration option.
Using Oracle DataServer product.
Oracle Database is UTF8
Progress database is UTF8.
Neither BLOB nor CLOB fields may have extents. (10885)
FACT(s) (Environment):
OpenEdge 10.2B
Oracle DataServer
All Supported Operating Systems
CAUSE:
Bug#: OE00206545
FIX:
Extented fields (aka arrays) in the OpenEdge database do not currently support use of the clob datatype.
It will be necessary to re-architect the data type or reduce the number of characters used.
When using UTF8 databases the number of characters used by the format phrase of the Progress / OpenEdge field definition will trigger the DataServer migration tool to pick a datatype that is equivalent within Oracle and large enough to handle the requested number of multi-byte characters.
When using 2001 characters or more as the format phrase for a character data type the DataServer code understands that the most typical supported type for Oracle is nclob/clob.