Maximum Open Cursor Exceeded
Posted: Thu 26 Mar 2015 12:28
Hi,
We're using stored procedures for CRUD operations in our system
Some of them returns data with ref_cursor.
CURSOR_COUNT is 1000 on Oracle.
When we try to loop a sp shown as below, we're facing with error :
Devart.Data.Oracle.OracleException:
ORA-01000: maximum open cursors exceeded ORA-06512: at "DB_TEST.SP_TEST"
Can you please offer a solution about this issue?
We're using stored procedures for CRUD operations in our system
Some of them returns data with ref_cursor.
CURSOR_COUNT is 1000 on Oracle.
When we try to loop a sp shown as below, we're facing with error :
Devart.Data.Oracle.OracleException:
ORA-01000: maximum open cursors exceeded ORA-06512: at "DB_TEST.SP_TEST"
Code: Select all
for (int i=0; i< 2000; i++)
{
ISingleResult<SP_TESTResult> result = ContextManager.Context.SP_TEST(param1, param2);
...
}