hi did u get the answer for the same ?

i am able to create a sp with data type text but when i run it on server calling it...