Kbase P6268: ORA-00604: error occurred at recursive SQL level 1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/02/2003 |
|
Status: Unverified
FACT(s) (Environment):
Oracle Dataserver
SYMPTOM(s):
ORA-00604: error occurred at recursive SQL level 1
CAUSE:
The following situation occurs when ORACLE does not have an available cursor which it needs to process a sql statement.
FIX:
The OPEN_CURSORS set within init.ora files should be higher than the progress connection parameter, -c, by 10 to 20.