Request: Variable number of arguments in Stored Routines

Some Stored Routines would be more powerful/usable if we are able to declare a variable number of arguments. Two special functions may return the number of passed args, and the value of a given arg.
As an alternative, you could implement optional parameters with a DEFAULT value, but this is less powerful.
I think that this is only relevant for IN parameters, not OUT/INOUT.