| How to edit the value of open cursors [message #61745] |
Mon, 24 May 2004 05:19  |
Daniel
Messages: 47
Registered: February 2000
|
Member |
|
|
Hi,
I do several "SELECT" at one time and I recive message TOO MANY OPEN CURSORS, obviously I close the cursors after the operations ends but I need to increment the value of number cursors.
How can I do?
|
|
|
|
| Re: How to edit the value of open cursors [message #61748 is a reply to message #61745] |
Mon, 24 May 2004 09:36  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
-- open cursors in your session
select * from v$sesstat where statistic#= 3;
-- open cursors owned by you
select * from v$mystat where statistic# = 3;
Be carful not to simply increase open_cursors in your init file - you could be masking a cursor leak in your code.
1.) in pl/sql, if a normal cursor is opened in a proc/funct, then when you return to a higher level scope, the cursor will automatically close.
2.) make sure that your error handling closes any cursors you may have opened.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
