Closing cursors - but its does not? Error: maximum open cursors exceeded [message #645158] |
Sat, 28 November 2015 00:30 |
wmgonzalbo
Messages: 98 Registered: November 2008
|
Member |
|
|
Hi OracFAQ,
We have a batch run that processes a huge amount of accounts - it does alot of processing per accountID.
We have an Oracle package who does the following:
* Processes data
* Has Stored procedures that contains SQLs and outputs a cursor which the java BE code reads and processes the dataset/cursor (together using other stored procs in the package as well) and stores it as one huge CLOB.
We checked the java code, it explicitly closes the cursors of the procs after its done reading them.
It also does a Commit after its done on each AccountID.
But we still get the error: ORA-01000: maximum open cursors exceeded
During execution, I monitored the highest open cursor count in the DB, and it just keeps increasing.
For now as a work around, we've set our max open cursor value in thousands range.
Any thoughts or advice on this on how to properly resolve this?
Database: Oracle 12c
Regards,
W
[Updated on: Sat, 28 November 2015 00:32] Report message to a moderator
|
|
|
|
|