This week's giveaway is in the Spring forum.
We're giving away four copies of Learn Spring Security (video course) and have Eugen Paraschiv on-line!
See this thread for details.
Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

new jdbc exception

 
Hareesh Ram Chanchali
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
i am getting this exception

ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded

what should i do
[ March 15, 2005: Message edited by: Bear Bibeault ]
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
exception itself is telling problem,

paste the code here

thanks
 
Ed Wallen
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You have a limited number of resources on your Oracle instance. This is governed by the startup parameter "OPEN_CURSORS". This dictates how many cursors Oracle may have open at any given time. Sounds like you need to work with your DBA and tune your application and database.

-Ed
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Ed Wallen:
You have a limited number of resources on your Oracle instance.


Yes there are limited number of resources, but they are sufficient enough.

There might be some problem in code like open connection or else, that is why I asked for code :roll:

Otherwise ORA-00604 itself is very confusing

This error is always followed by a reason !!! and if reason can not be corrected then only recommendation would be to contact Oracle Support.

I found same on a website

For Oracle version: 8i
ORA-00604 error occurred at recursive SQL level num

Cause: An error occurred while processing a recursive SQL statement. A recursive SQL statement is one that applies to internal dictionary tables

Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support.



For Oracle version: 9i
ORA-00604 error occurred at recursive SQL level string

Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).

Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services.



thanks...
[ March 04, 2005: Message edited by: Shailesh Chandra ]
 
Hareesh Ram Chanchali
Ranch Hand
Posts: 110
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks guys i got it cleared by incresing resources and also optimized my program
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic