how to kill a cursor in v$open_cursor
445144Jun 6 2005 — edited Jun 6 2005Hi all,
I've a stored procedure named ana_emp that returns data into a ref cursor (oracle 8.1.7).
The way I call this stored procedure from my vb.net app is to write this statement:
"begin ana_emp(null,'89', CUR_OUT=>:CUR_OUT); end;" and then to execute the statement.
The issue I encounter is that the cursor CUR_OUT is closed correctly after I close my connection to the db, but the cursor related to the statement "begin ana_emp(null,'89', CUR_OUT=>:CUR_OUT); end;" doesn't. It appears for few minutes into the view v$open_cursor. After a while it desappears.
BUT in this WHILE many other users do the same, so I quickly reach ora-01000 error (max open cursors).
How can I do to close the cursor just after I used it?
I cant operate on the max_open_cursors parameters.
TKS
Giovanni