Re: [cx-oracle-users] Close Cursor - Best Practise
Brought to you by:
atuining
|
From: avinash n. <avi...@or...> - 2014-09-04 11:15:41
|
Hello Anurag, The Cursor object can be reused many times for different types of queries and DMLs. Unless you require to concurrently execute multiple SQLs/DMLs you can serially use the same cursor for multiple queries. In fact once you close a cursor object you will have to create a new one. If you see any inconsistency please post it in the forum. Best Regards, Avinash On 9/3/2014 9:49 PM, Anurag Chourasia wrote: > I will be executing 4 SQL Queries one after the other. > > Each query will return a good number of records (> 50000 Records) > > I am planning to use the same cursor variable for all the queries to > fetch the records into. > > What is the best practise w.r.t closing of the Cursor? > > Shall i close the cursor after executing and fetching records for each > query? > Or > Shall i use the same cursor without closing and fetch the records and > close it only once after having executed all 4 queries? > > Regards, > Guddu > > > ------------------------------------------------------------------------------ > Slashdot TV. > Video for Nerds. Stuff that matters. > http://tv.slashdot.org/ > > > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |