All the permissions are good.Thanks for the reply.

I found the soultion. Its really crazy, I do not know why and how but it worked.

I droped the procedure and recreated and it worked like that.

Thanks

Satish