<str> clause is not valid for stored routines

  Explanation:  For stored routines the specified clause is
  illegal syntax.

  User Action:  Reenter the definition an omit this clause.