Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to return multiple records from procedure?

Answer Posted / swapna

You have to return the selected cursor as OUT parameter and
again you have to fetch the data from that OUT cursor.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what does myisamchk do? : Sql dba

961


Is sql workbench free?

927


What is pls_integer in pl sql?

1029


What is the difference between subquery and correlated query?

982


Why commit is not used in triggers?

987


what is the difference difference between procedure and packages

10243


Can you join views in sql?

896


How do I create a sql script?

1047


What if we write return in procedure?

1331


What is a null value?

1079


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

966


what are date and time functions in mysql? : Sql dba

924


What is an exception in pl/sql?

1005


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3944


What are the types pl/sql code blocks?

1066