Home » SQL & PL/SQL » SQL & PL/SQL » About Ref Cursor (Closing of Ref Cursor)
About Ref Cursor [message #275444] Sat, 20 October 2007 02:39 Go to next message
Messages: 19
Registered: October 2007
Location: Mumbai
Junior Member

Hi All
I am Using the Ref Cursor in Store Procedure(SP) in the Body part i Just open the Cursor.
Like Open RefXYZ for 'select..........' this Sp is Used by Our .Net Team. Just Suggest me How and When this cursor Will be Closing.

Thanks And Regards
Re: About Ref Cursor [message #275445 is a reply to message #275444] Sat, 20 October 2007 02:46 Go to previous message
Michel Cadot
Messages: 65150
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How? using the "close cursor" function that exists in your prorgamming language or calling a PL/SQL function that does a "close p_ref_cursor".

When? When you no more need it. Possibly never (it is automatically closed when you close the session or at the end of your program).

Previous Topic: Pivot like this using DECODE???
Next Topic: invalid connect
Goto Forum:

Current Time: Mon Aug 21 22:41:19 CDT 2017

Total time taken to generate the page: 0.08317 seconds