Kbase 20836: Error 1445 Running Stored-procedures - ORACLE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/06/2002 |
|
Solution ID: 20836
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Open cursor error, please increase -c. (1445)
Error occurs when running ORACLE stored-procedures or the send-sql-statement functionality
The error may happen even when the -c is set to a higher number
CAUSE:
The client process ran out of cursors. The DataServer ORACLE takes up to 50 cursors from the main cursor pool (specified by -c) and keep them under a separate stored-procedures pool. If more than 50 cursors are open for stored-procedures, then error 1445 is received.
FIX:
Verify that all stored-procedures within program are closed properly after the processing finishes, so the DataServer does not need to keep more than 50 cursors for stored-procedures.
Refer to the "close stored-procedure statement" within code:
CLOSE STORED-PROCE <proc-name> where proc-handle = <handle>.