AfelionДоброго времени суток.

В интернете нигде не смог найти овет на мой простой вопрос: может ли триггер вызывать процедуру?Может.
http://dev.mysql.com/doc/refman/5.5/en/trigger-syntax.html It can be easier to define a stored procedure separately and then invoke it from the trigger using a simple CALL statement. This is also advantageous if you want to execute the same code from within several triggers. Но с оговорками:
There are limitations on what can appear in statements that a trigger executes when activated:

The trigger cannot use the CALL statement to invoke stored procedures that return data to the client or that use dynamic SQL. (Stored procedures are permitted to return data to the trigger through OUT or INOUT parameters.)

The trigger cannot use statements that explicitly or implicitly begin or end a transaction, such as START TRANSACTION, COMMIT, or ROLLBACK.