Kbase P64344: Errror (6483) when wrong ORACLE version referenced
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/31/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1C
SYMPTOM(s):
Getting error when running code against Oracle database
Please also verify you have select privileges on the needed system tables and the proper version of ORACLE (7 or 8) was selected when the schema holder was created (328) (6483)
Unable to locate inex '_Seq-Name' on table '_Sequence' for procedure 'prodict/ora/_ora_lkg.p'.(7967)
Using Oracle client 9i (9.0.1)
Schema image has "Oracle version" = 7
User has all correct SELECT privileges
CAUSE:
Oracle version referenced within the schema image is incorrect
FIX:
Change "Oracle Version" = 8, so that metaschema tables can be accessed.
Steps on how to do this;
1. Dump the schema holder df
2. Change the value for DB-MISC13 to 8
DB-MISC13 8
3. Save the file
4. Go to Oracle Utilities -> Delete DataServer schema
5. Then reload the newly saved file