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
nirajksharmacpr
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
Niraj
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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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).

Regards
Michel
Previous Topic: Using an Index
Next Topic: ORA-00060: Deadlock detected from 2 INSERT INTO 2 tables
Goto Forum:
  


Current Time: Fri Feb 07 18:32:35 CST 2025