Hi Amol,
I don't work with Oracle so cannot help you. You can try to post your question in the Oracle forun here on UT.

>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