Re: OUT Params and error 1414

[Roland Bouman]

In your call, you are passing literals - not variables.
Thats fine for the IN parameters, however, the out parameter is having a problem: how can MySQL assign the 2 as in

SET spTrigger = 2;

to the literal value

1

that you passed in

call fill_roughing(3,2,1)

? It can't, because 1 is just 1; it will never become 2.

This however should work:

set @spTrigger := 1;
call fill_roughing(3,2,@spTrigger);

Now, we pass the _variable_ @spTrigger. When you'd now do:

select @spTrigger;

you can witness that the value of @spTrigger has indeed changed due to the call.

NOTE: I used @spTrigger as an identifier; this has nothing to do with your parameter definition being called spTrigger. We are dealing with two distinct variables here.
@spTrigger could just as well have been called @coleSlaw, and it would still work.