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.
MIHIR KAR#Oracle_DB #UNIX beginnerAsked:
Who is Participating?
 
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 KAR#Oracle_DB  #UNIX beginnerAuthor Commented:
Thnks for the useful tips.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.