On 10 Mar, 2012, at 7:06 pm, Cifer Lee wrote:

> 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* ?


You can pass the argument directly as long as it is not an INOUT parameter.

Antony T Curtis
atcur...@gmail.com

0523 C487 9187 6972 6894
AEC7 3087 F819 B477 B687

Reply via email to