Poco Data library stored procedure and output parameter

[rishp]

Hello,
I think POCO is excellent library for C++, and I am just experimenting so that I can use for our project.
I am using source code from latest trunk as I want output parameters from stored procedures.
we are using Mysql.
My requirement is to get out(string) from session, i.e. stored procedure give output in varchar and I want to retrieve.
As this is the errormsg from stored procedure it is very important.

Really thankful to POCO library.

[Royce]

I don't think even the latest code handles varchar just yet. There is a work-around however. In SQL concatenate your varchar result with an empty string and the result will be your varchar converted into a string that Poco can handle.

e.g. instead of SELECT some_varchar_field FROM ...
do
SELECT CONCAT(some_varchar_field, '') FROM ...

[rishp]

Thanks for reply.
Actually I am interested in getting output from stored procedure and not from select query.

for e.g.
sp_Affected_Rows`(IN pi_RowCount TINYINT UNSIGNED,
INOUT po_ErrMessage VARCHAR(200));
I would like to get po_ErrMessage in out(string) function. Is it possible?

[alex]

I would like to get po_ErrMessage in out(string) function. Is it possible?

Possible. Last time I worked on it, there were blocking MySQL bugs. See comments in ODBCMySQLTest.cpp