| 9i.Reports [message #89265] |
Mon, 12 January 2004 19:04  |
sivaram
Messages: 4
Registered: January 2004
|
Junior Member |
|
|
I developed a report which consists of 107 cells with all different values from 4 basetables.
I have written 4 queries and run them individually and paster "foreach" part of websource to the main websource.
After some values, when i tried to run report, browser is giving
ORA-01000: maximum open cursors exceeded
excepton.
please help me in this
|
|
|
|
| Re: 9i.Reports [message #89266 is a reply to message #89265] |
Tue, 13 January 2004 04:58  |
Ganesh Khanna
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
|
When the no. of open_cursors exceeds the value which is defined in the init.ora file, you will get the ORA-01000 error. Go and increase the values of the paramter.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
