Hi,

I have to call a stored procedure with mysql++.
The procedure is something like

Procedure proc( firstparam varchar(20), second param varchar(20) )
begin
[some code]
select firstReturn, secondReturn;
end

So, i am calling this stored procedure with Query.store() with the sql
"call proc('one','two')".

It returns me an exception , telling me that the procedure can't return
a result set.

How to use stored procedure that retruns some parameters with mysql++ ?

Thanks

--
Denis ERCHOFF

Cell. +39 333 1985619
Email: erchoff (AT) klan (DOT) it


--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

Ok, resolved.

I have added the option "multi_statements" :

Con.set_option( mysqlpp::Connection::Option:pt_multi_statements, true);


Denis ERCHOFF a écrit :

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw