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