Kbase 18539: ORA-00907: Missing Right Parenthesis Occurs During 8.2C Protoora
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/29/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.2C
Oracle DataServer
SYMPTOM(s):
Oracle Error 907 is encountered when migrating a Progress database to Oracle
ORA-00907: missing right parenthesis
Incorrect SQL code is displayed within the .sql file generated by prootora
CAUSE:
For example, a field that is defined in Progress as mandatory might is seen as
FieldXXX varchar2 (3) NOT NULL DEFAULT '',
The correct syntax should be:
FieldXXX varchar2 (3) NOT NULL,
When the code is executed in ORACLE, the following 907 error might occur:
Missing right Parenthesis
FIX:
These problem is fixed in later patches of Progress 8.2C & and Progress 8.3A.
FIX:
A workaround is to manually editing the SQL code within the .sql file. Remove
all syntax after the NULL, [DEFAULT ''], so that it does not fail in ORACLE.