there are queries compiled that reference routine "<str>"

  Explanation:  You tried to change metadata associated  with  the
  specified  routine  however a compiled query exists that depends
  on the current routine metadata.

  User Action:  You may have to disconnect, and re-attach  to  the
  database before executing this action.