The problem is that the procedure is taking a lot of time to execute
Also,This problem is happening only after i deployed the code in unix server.In local,its working fine
Can someone please explain why the procedure is called many times even though there is no looping.Is it somehow related to the fact that the procedure is returning 40 cursers
So say I select CustID: #2 from the drop box. Instead of displaying CustID #2 it will display CustID #3 Personal Information and with that CustID it will link to ID: 3 in the Orders table and display that correct Order info..