| ORA-01000: maximum open cursors exceeded error [message #390064] |
Wed, 04 March 2009 16:03  |
dksampat
Messages: 12
Registered: December 2006
|
Junior Member |
|
|
Dear All,
We have a strange issue for a common error. We are running a PLSQL Package and we are hitting "ORA-01000: maximum open cursors exceeded error". When I checked the gv$open-cursor, I found that 90% of the open cursors has a sql termed "SELECT NULL FROM DUAL;"
Kindly please let us know how to move forward on this issue? Is this a cursor leak in the package or is there anything that needs to be set in the DB side?
Regards,
DK
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
