I figured that it is not possible to do what I was trying to do using Store Porcedure so I had to write the function in the code page itself. Thanks all for your help. :)