Error max cursor open in store procedure oracle

2 posts, 0 answers
  1. Phạm Quang
    Phạm Quang avatar
    2 posts
    Member since:
    Aug 2012

    Posted 13 Oct 2015 Link to this post

    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

  2. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 15 Oct 2015 Link to this post

    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
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.

     
  3. DevCraft banner
Back to Top