The Logic given below has really finished my doubt which i was having in retrieving the output parameter in sql queries...

I knew it how to fetch the output from front...

hey may be the second solution provided by you as concatenation of more than on varchar variables work out for me may be i hav got the hint so...

May be i didnt explained the query exactly actually i have a very big query to be written in the stored procedure which takes a lot of parameters and text...