File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes new jdbc exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "new jdbc exception" Watch "new jdbc exception" New topic
Author

new jdbc exception

Hareesh Ram Chanchali
Ranch Hand

Joined: Jan 31, 2005
Posts: 110
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 ]

Hareesh Ram Chanchali
SCJP 5.0, IBM Certified Solution Designer
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

exception itself is telling problem,

paste the code here

thanks


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Ed Wallen
Ranch Hand

Joined: Feb 11, 2002
Posts: 34
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

Joined: Aug 13, 2004
Posts: 1081

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

Joined: Jan 31, 2005
Posts: 110
thanks guys i got it cleared by incresing resources and also optimized my program
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: new jdbc exception
 
Similar Threads
please help me
ORA-00932: inconsistent datatypes exception using WSAD 4.0.3 and oracle 8
utl_file error - invalid file operation
Error code of ORA-12645 for DB connection
Debugging HTTP 500