Hi All,
I have a front end data window screen which is calling 4 stored procedures to retrieve data and populated the data in a graph. Each stored procedures has 1 OUT refcursor variable which will retrieve records to that front end screen to display the records . The front end application is taking total time of 10 secs to display the final output. But when i execute each procedure in TOAD it was taking just 1 second total run time for all the 4 stored procedures. What will be the issue ?. Is it something issue in the front end screen of retrieving those ref cursor records and displaying the data or some network issue between front end and database server.