Is it possible to pass the NEW and the OLD tables from a trigger into a procedure in MySQL?

Question

Is it possible to pass the NEW and the OLD tables from a trigger into a procedure in MySQL? I suspect no, since there is no such a datatype as table that a procedure accepts. Any workarounds possible?

Ideally it would look like this:

CREATE TRIGGER Product_log AFTER UPDATE ON Product
  FOR EACH ROW BEGIN
    call logChanges(OLD, NEW);
  END;

Answer 1

You can explicitly pass each field:

CALL logChanges(OLD.colA, OLD.colB, NEW.colA, NEW.colB);

Or if logChanges must be sufficiently generic that it can handle such calls from different tables, one could concatenate the field values into a single string using a suitable delimiter (e.g. the unit separator):

CALL logChanges(CONCAT_WS(CHAR(31), OLD.colA, old.colB),
                CONCAT_WS(CHAR(31), NEW.colA, NEW.colB));

Or if data types must be preserved, one could insert the records into a temporary from which logChanges reads.