GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 197 of 213    Print  
Ref Cursors
How many ref cursors can be dynamically opened in stored procedures for a session?


  
Total Answers and Comments: 2 Last Update: November 24, 2009     Asked by: Mohamed Harish 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 10, 2009 08:59:18   
sunraajkumar Member Since: June 2008   Contribution: 8    

RE: Ref Cursors

more then one query open same cursor name at same time
(use unlimited query)


 
Is this answer useful? Yes | No
November 23, 2009 22:37:21   
kondapallikalyan Member Since: November 2009   Contribution: 2    

RE: Ref Cursors
We have two types of ref cursors

1. Week typed
2. Strong typed

Ex: Type <Ref cursor Name> is ref cursor /* this is week typed*/

Ex:Type <Ref cursor Name> is ref cursor return <Rowtype> /* this is strong type

 
Is this answer useful? Yes | No

 Related Questions

What purpose we are using cursors? why you need cursor? why i write into clause when i want to write select statement.when you are using out and inout paramaters mode in procedure......pls explain ...

How many ref cursors can be dynamically opened in stored procedures for a session? 
Latest Answer : We have two types of ref cursors1. Week typed2. Strong typedEx: Type is ref cursor /* this is week typed*/Ex:Type is ref cursor  return /* this is strong type ...


 Sponsored Links

 
Related Articles

Be Prepared for Tech Job Cuts

Even one of the most flourishing and possibly the strongest industries of the future are not experiencing the economic crunch. The tech industry is now experiencing massive job losses in different categories. Although you will still see innovations almost every day from the tech industry through th
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2010 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape