*** api - stored procedure - OUT param ***

[balaji srinivasan]

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