MySQL Lists: mysql: why can not pass constant to stored procedure?

List:	General Discussion	« Previous Message Next Message »
From:	Cifer Lee	Date:	March 11 2012 3:06am
Subject:	why can not pass constant to stored procedure?
View as plain text

when we call procedure
normally we declare the parameter out of the procedure and pass the
variable to procedure
like this

set @x=1;
call *a_procedure*(@x);

why can not directly pass the digit  1  to the* a_procedure* ?

Thread
• why can not pass constant to stored procedure?	Cifer Lee	11 Mar
• Re: why can not pass constant to stored procedure?	Antony T Curtis	11 Mar