Passing rows as routine parameters
Row type values and arrays of row type variables can be passed as parameters to procedures and functions. Procedures support these data types as IN, OUT, and INOUT parameters.
The following is an example of a procedure that takes a CHAR type
as an input parameter, modifies a field in the output row parameter
and then returns.
CREATE PROCEDURE p(IN basicChar CHAR, OUT outEmpRow empRow)
BEGIN
SET outEmpRow.field2 = basicChar;
END@
CALL p('1', myEmpRow)@