hi sergey,
thanx for u r reply
its working perfectly with SQL server, but its not working with orcale
so pls tell me how should i get the same result in oracle
also tell me how create a dynamic cursor in proc in oracle


thanx in advance,
amol