Stored Proc - Output Parameter Does Not Work With Nested Level

Anyone can help with this question: thanks





in a asp .net application, I call a stored procedure which have a output parameter.


the output parameter works find in sql session, but not in the asp .net application.





if I put select msg_out = "error message" in position A(see below for stored proc), it works fine


if I put them inside the if statement, the output parameter wont work in asp .net application, but fine in SQL session


The stored proc was created like this:





Create procedure XXXXXXX


(@msg_out varchar(80) OUTPUT


)


as


begin





while exists (*******)


begin


//position A


if certain condition


begin





select msg_out = "error message"


return 1


end





end








end








end





It seems to me that anything inside if - the second begin...end - it wont get executed.





Anyone has got a clue





Any help much appreciated!