MySQL Forums
Forum List  »  Stored Procedures

Re: URGENT: return result set in SPs
Posted by: Roland Bouman
Date: August 22, 2005 03:56AM

Chagh wrote:
> so i can not use only an SP in my code and i
> should run a query to get the result set from temp
> table after calling the SP. is that right?
> is there any other way to do this? so why we have
> SPs at all? they can just do DMLs.

No, not exactly. You can capture a resultset from the stored procedure in a external host language, like the C++ API. you just can't capture it in another procedure. Also, you can do a SELECT inside a sp, but the results are immediately returned....to the client program, not to a subsequent procedure or the calling context.

Maybe you should file a feature request.

> and another question: is MyODBC 3.51 tested with
> MySQL 5.x? can we call an SP from Delphi via
> MyODBC? (i tried to do so (using ADO an a data
> provider for OLEDB) but i think somewhere in
> passing the call statement it had put {} around
> "call sp()" statement so that mysql returned an
> error about the syntax.)

Sorry, don't know anything 'bout that. Try the connector forums.

good luck!

Options: ReplyQuote


Subject
Views
Written By
Posted
4585
August 21, 2005 07:24AM
3611
August 22, 2005 02:54AM
Re: URGENT: return result set in SPs
3462
August 22, 2005 03:56AM
6193
August 28, 2005 09:39PM


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.