Kbase P83413: '' default value missing for new VARCHAR2 column (Oracle DSV migration tool)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
Progress 9.1D
SYMPTOM(s):
'' default value missing for new VARCHAR2 column
New character field has INITIAL "" in delta.df
Use "delta df to ORACLE conversion", with box "Include Default" toggled
CAUSE:
Bug# 20040608-027
FIX:
Either,
upgrade to 9.1E, 10.0B or 10.1A.
or,
edit the .sql file generated and add the option DEFAULT ' ' as per example:
ADD newfield2 VARCHAR2 (30) DEFAULT ' '