[cx-oracle-users] Close Cursor - Best Practise

[Anurag C. <anu...@gm...>]

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