Hi,

I have written some Stored Proc in ORACLE for making some calculations, in that i am invoking CURSORs for LOOPing.
It takes more than 30 mins (1/2 hr) to excute the PROCEDURE for less than 700 records.
I have tried to reduced the execution time by making the INDEX on the tables, but that also doesn't work.

How should i reduced the execution time in procedures.


Thanx in advance,
Amol