Kbase P101175: The Oracle DataServer Delta SQL utility does not add ## for the extent field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/10/2008 |
|
Status: Unverified
SYMPTOM(s):
The Oracle DataServer Delta SQL utility does not add ##<number of extents> for the extent field
FACT(s) (Environment):
The problem is only apparent when a regular progress character field is changed to an extent field
The SQL-WIDTH is chosen for the field length
The field length is also not being properly calculated for each extent fields
Oracle DataServer
OpenEdge 10.x
CHANGE:
Deleted the existing character field, and re-created the field with the same name but created as an extent field.
CAUSE:
Bug# OE00113647
FIX:
Install Service pack OpenEdge 10.0B02 or later.
If Service pack upgrade is not possible, follow the workaround below:
The workaround is to manually modify the SQL in the .sql file to the correct field name and the length for the extent fields.
Currently, the SQL is generated by the Oracle DataServer's Delta SQL as the following. In this example the field had 6 extents.
ALTER TABLE MYTABLE
ADD myfld21 VARCHAR2(732)
ADD myfld21 VARCHAR2(732)
ADD myfld21 VARCHAR2(732)
ADD myfld21 VARCHAR2(732)
ADD myfld21 VARCHAR2(732)
ADD myfld21 VARCHAR2(732)
;
Manually modify the SQL to the following:
ALTER TABLE MYTABLE
ADD myfld2##1 VARCHAR2(60)
ADD myfld2##2 VARCHAR2(60)
ADD myfld2##3 VARCHAR2(60)
ADD myfld2##4 VARCHAR2(60)
ADD myfld2##5 VARCHAR2(60)
ADD myfld2##6 VARCHAR2(60)
;