Re: Error: "Procedure X can't return a result set in the given context"

[Lawrence Holtsclaw]

I really hate to tell you this, but the IN absolutely must have everything to do with it because that was literally the only difference between what worked and what didn't. In case it helps, this procedure is three-levels deep in calls (Procedure A -> Procedure B -> Procedure C). It was the only procedure without explicit IN declarations (a typo on my part that I initially ignored). I changed it solely beause I had already tried about everything else but that.

I could send you the procedures but you'd be unable to test drive it without a couple of large tables and a couple of dynamically loaded UDF's. Considering someone else has supplied an extremely terse test case, I'll assume that's not neccessary. Before you ask, I bypassed the UDF calls during testing without effect so the use of them is not relevant.