Kbase P12062: Error 3588 trying to access a sequence
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/7/2003 |
|
Status: Unverified
SYMPTOM(s):
Error 3588 trying to access a sequence
Sequence <sequence> not found. (3588)
Sequence name that was migrated to oracle was created using underscore instead of dash.
Have application designed using the object names using dash
CAUSE:
There are restrictions for naming ORACLE objects. Oracle supports only alphabetic
characters (A-Z and a-z), digits (0-9), and the special characters $, &, # and _ .
If you use ProtoOra (Progress-to-ORACLE) utility, it will replace the characters that ORACLE does not accept with the underscore ( _ ) in the Oracle definition but in the schema holder created by the utility it will keep the object name as it was.
If you loose the schema holder created by the utility and don't want to rerun ProtoOra, you can simply create a new schema holder but after the schema pull you must manually change the names using the data dictionary.
Remember that this is not the only one adjustment that ProtoOra utility does. See Progress Documentation for details.
FIX:
Change the name of the sequence only in your schema holder side using Data dictionary.