Please suggest [message #36121] |
Tue, 06 November 2001 10:42 |
Poonamb
Messages: 16 Registered: October 2001
|
Junior Member |
|
|
Hello,
Below is the requirement :
I have a main table which returns multiple rows and for each row, a bunch of procedures are being called to populate different fields from different tables.
This slows the process tremendously as from the client, each procedure is being called in a loop. I intend to create a cursor in my package which will extract these initial rows and then for each, within my package, call respective procedures. Do everything at the backend and return an exhaustive record set to the front end.
BUT the problem is, how do I return all this? It is most appropriate if I can return a cursor will all data. Please explain how.
Thanks in Advance
Please suggest what is the solution??
----------------------------------------------------------------------
|
|
|
Re: Please suggest [message #36126 is a reply to message #36121] |
Tue, 06 November 2001 17:15 |
Brian
Messages: 38 Registered: October 1999
|
Member |
|
|
Hello,
You could pre-process the data and store it all into the table. Then the query will just retrieve the records required.
But that would mean you would need to re-run the calculations in a timely manner.
Is that a viable solution? Not very good if you have real time data. Good if you have time to do the calculations.
----------------------------------------------------------------------
|
|
|
|