Skip navigation links

MySQL Forums :: Stored Procedures :: Error: "Procedure X can't return a result set in the given context"


Advanced Search

Re: Error: "Procedure X can't return a result set in the given context"
Posted by: Lawrence Holtsclaw ()
Date: October 18, 2005 08:35AM

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.

Options: ReplyQuote


Subject Views Written By Posted
Error: "Procedure X can't return a result set in the given context" 6470 Lawrence Holtsclaw 10/10/2005 01:20PM
Re: Error: "Procedure X can't return a result set in the given context" 4246 Per-Erik Martin 10/11/2005 08:00AM
Re: Error: "Procedure X can't return a result set in the given context" 3804 paolol 10/14/2005 09:01AM
Re: Error: "Procedure X can't return a result set in the given context" 5598 Lawrence Holtsclaw 10/18/2005 08:35AM
Re: Error: "Procedure X can't return a result set in the given context" 4307 Per-Erik Martin 10/18/2005 11:04AM
Re: Error: "Procedure X can't return a result set in the given context" 4443 Randy Cassidy 10/24/2005 01:00PM
Re: Error: "Procedure X can't return a result set in the given context" 8975 Randy Cassidy 10/24/2005 01:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.