Value assigned to <str> in the routine "<str>" truncated during
  call

  Explanation:  When calling a function or procedure you passed a
  character string value which was longer than could be held by
  the parameter.  SQL will therefore truncate the value during
  assignment to the parameter.

  User Action:  This is just a warning.  However, you should
  probably correct the strings length (possibly using the CAST
  function), or adjust the routine definition to avoid loss of
  data.