Kbase P5955: Error Oracle 1036, SDO's used
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/10/2010 |
|
Status: Unverified
SYMPTOM(s):
Error Oracle 1036 "Illegal variable name
umber"
Seems to be a random problem
CAUSE:
The Oracle error 1036 can happen due to a resource problem. Having no query-close statement makes opened cursors not reusable.
FIX:
Add query-close statement to all instances of dynamic queries in
SDO's.