Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: About :ORA-01000: maximum open cursors exceeded

    I use ado.net access oracle. when i execute a sql many time, OracleException class throw a exception, upon.
    how do I solve it ?

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    increase the number of open_curors in your initSID.ora file

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    maybe you should analyze if all the established connections are correctly closed an releasing there resources .

    setting the resource_limit = true in init.ora might help and the assigning of a profile with settings idle_time and connect_time to proper values ...

  4. #4
    Join Date
    Feb 2004
    Posts
    5
    Originally posted by osy45
    maybe you should analyze if all the established connections are correctly closed an releasing there resources .

    setting the resource_limit = true in init.ora might help and the assigning of a profile with settings idle_time and connect_time to proper values ...
    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •