Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 99
  • Last Modified:

Oracle cursor lifecycle inside procedure.

How to find out how many cursor are in open stage inside a procedure and how to close all cursor at a time.
0
MIHIR KAR
Asked:
MIHIR KAR
1 Solution
 
slightwv (䄆 Netminder) Commented:
I don't believe there is a way to close all with a single call.

I'm also not sure of a way to say what cursors belong to what specific procedure's execution.  You might e able to loop through some of the V$ views and look for open cursors and tie them back to a specific procedure but is all that work really worth it?

When the session executing the procedure ends any remaining open cursors will be closed.
2
 
MIHIR KARplsql beginnerAuthor Commented:
Thnks for the useful tips.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now