From: Johan De Meersman Date: March 27 2012 10:46am Subject: Re: why must user variable in EXECUTE USING clause ? List-Archive: http://lists.mysql.com/mysql/227046 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Cifer Lee" > > it seems none of you hava answered my question..... Yes, that happens :-) I'm slightly confused as to the difference between "user variables" and "local variables", though. Are you saying you couldn't just declare @myvar and use it in your code? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel