problem is this is a 3rd party app, no re-write possible (it is bad code) but has not changed in 2 years.  However recompiling the bad stored proc did solve problem