new jdbc exception

[Hareesh Ram Chanchali]

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]

exception itself is telling problem,

paste the code here

thanks

[Ed Wallen]

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]

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]

thanks guys i got it cleared by incresing resources and also optimized my program