Using lots of cursors vs temp tables
755501Apr 13 2012 — edited Apr 16 2012I have a very large procedures that executes many cursors in it. Basically, there is 1 main cursor that gets the employee and within the FOR loop executes lots of others. Most of these other cursors return a couple records per employee, but they are beinge executed 20-30,000 times withing the main cursor. Thought about executing the cursor independenty for all employees and storingt he data in PL/SQL tables, btu not sure if that will help the performance of the procedure any. Does anyone have suggestions?
thanks