Kbase P97040: Getting Oracle error 1410 when running a FIND query with ROWID in the where clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
Progress 9.1x
OpenEdge 10.x
SYMPTOM(s):
Getting Oracle error 1410 when running a FIND query with ROWID in the where clause
ORACLE error -1410 see ORACLE Error Messages and Codes Manual (1255)
*** ROWID invalid
CAUSE:
Bug# 20040623-022
CAUSE:
The NO-ERROR option on the FIND statement does not trap the error ORA-1410.
FIX:
If the problem appears in Progress 9.1x:
- Upgrade to Progress 9.1E
- Apply Service Pack 9.1E01
If the problem occurs in OpenEdge 10.x:
- Upgrade to OpenEdge 10.0B
- Apply Service Pack 10.0B01
The standard Progress error message "Record not found" will appear instead. This will then allow to trap the error with the NO-ERROR option.