this stored routine may not be called from a trigger

  Explanation:  Not all stored  routines  may  be  called  from  a
  trigger condition or trigger action.  Routines which perform the
  following actions may not be called from triggers:  includes the
  DELETE,  INSERT,  UPDATE  data  manipulation  commands, includes
  transaction commands SET TRANSACTION, COMMIT,  or  ROLLBACK,  or
  calls a stored routine using the CALL statement, or references a
  user defined SQL function.

  User Action:  Correct the function or procedure to  comply  with
  these restrictions.