MySQL Forums
Forum List  »  Stored Procedures

*** api - stored procedure - OUT param ***
Posted by: balaji srinivasan
Date: March 24, 2005 03:56PM

Hi,

I have a question about calling stored procedures from the api (any api - perl, c, odbc, etc).
I'm able to call the a procedure from api and get any result sets it gives, for e.g:
CREATE PROCEDURE sp_bal()
BEGIN
SELECT * FROM person;
END

I'm able to call above and get result set.

But, for a stored procedure with *OUT* param, like:
CREATE PROCEDURE sp_bal2( OUT msg VARCHAR(20) )
BEGIN
SET msg = "Success";
END

How can I call this stored procedure and get the *OUT* param from a api?
I'm trying to do this past two weeks, and couldn't even find any clue from google.
My questions are:
1. Does any mysql api supports *OUT* param from stored procedure?
2. If yes, how to do it?
3. If not, what is the mysql plan to support that?

I appreciate any suggestion.

Thanks,
Balaji

Options: ReplyQuote


Subject
Views
Written By
Posted
*** api - stored procedure - OUT param ***
4872
March 24, 2005 03:56PM


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.