Skip to Content
0
Former Member
Jan 03, 2008 at 07:15 PM

ORA-01000: maximum open cursors exceeded

49 Views

Post Author: prashant

CA Forum: Data Connectivity and SQL

I successfully created reports using CR4E on windows, deployed JSPS to Websphere running on windows and was able to view a large reports using JNDI connection resources to Oracle 10g.

Every time report is called, it consume 12 cursors from of the database. Open_cursors count is 300. After 24 or 25 iteration of this report, it throws ORA-01000: maximum open cursors exceeded error.

Has anyone seen this problem, and if so where can I find a hot fix/patch. Any help would very much be appreciated.