Hello experts i have an issue regarding passing values to the procedure.
In the performance standpoint, can a large volume of single parameter be passed into the stored procedure. For ex. 300 records are stored in a temptbl and the temptbl is passed into the procedure via the parameter. An update statement is run for every student, selected through the cursor from the table. In the applicaition standpoint its taking too much time to process the data. Will this be fine if i run the procedure for every student record.
[Edited by sbala on 03-22-2001 at 02:38 PM]