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: 64953
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: Using an Index
Next Topic: ORA-00060: Deadlock detected from 2 INSERT INTO 2 tables
Goto Forum:

Current Time: Sat Jun 24 07:25:22 CDT 2017

Total time taken to generate the page: 0.23518 seconds