Error max cursor open in store procedure oracle

[Phạm Quang]

Hi all,

i have error when use openaccess telerik connect to oracle like this:
2015-10-13 16:44:48,764 [18] ERROR DataProvider [(null)] :: Telerik.OpenAccess.Exceptions.DataStoreException: Telerik.OpenAccess.RT.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
ORA-06512: at "XXXXXXXXXX_PROCEDURE", line 369
ORA-06512: at line 1
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeUpdate()
   at OpenAccessRuntime.Relational.RelationalQueryResult.createFetchResult(Connection conParam, SqlDriver sqlDriver, Boolean scrollableParam, FetchSpec fetchSpec, RelationalCompiledQuery relationalCompiledQuery, RelationalStorageManager storageManager, Object[] paramVals, Int32 fetchSize, Int32 maxRows)  ---> Telerik.OpenAccess.RT.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
.
What can i do fix ?

 

Thanks

[Ralph Waldenmaier]

Hello Phạm Quang,
Thank you for contacting us.
Based on the provided information, I guess that you are using a procedure that somehow fires queries in your database that lead to a heavy usage of cursors in the system. According to this link, you can increase the number of allowed open cursors in your database. Though leading to more memory consumption for the database.
Additionally, I would check what the procedure actually does. Are there some resources that are not freed correctly while executing the procedure? Any recursive calls?

I hope this information is helpful for you.
Do come back in case you have any other question


Regards,
Ralph Waldenmaier
Telerik