List:General Discussion« Previous MessageNext Message »
From:Antony T Curtis Date:March 11 2012 4:17am
Subject:Re: why can not pass constant to stored procedure?
View as plain text  
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
atcurtis@stripped

0523 C487 9187 6972 6894
AEC7 3087 F819 B477 B687


Thread
why can not pass constant to stored procedure?Cifer Lee11 Mar
  • Re: why can not pass constant to stored procedure?Antony T Curtis11 Mar