Kbase P12588: REPLACE/CONCAT not > 32000 bytes (DSV-Verify utility)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
Progress 9.1D
SYMPTOM(s):
REPLACE/CONCAT may not result in data > 32000 bytes
Message seen during running "Verify Table Definition" Oracle dataserver utility
Problem only seen on huge table which has many fields and indexes
The fields of the table also have long descriptions which are not within Oracle.
CAUSE:
The description field gets verified. This field does not exist in Oracle, thus there is discrepency. The Verify utility uses a variable to store its discrepency and there is a 32K limit on the 4GL variables. The long descriptions causes the variable exceeding 32 K limit.
FIX:
Suppress the descriptions within the schema holder