[Devel] [ openser-Bugs-1618322 ] avp_db_query cannot call mysql stored procedures

[Kobi Eshun]

With the version of MySQL I'm using (5.0.24), if the stored procedure  
returns even 1 result set, then it is necessary to flush the list  
with mysql_next_result(). Otherwise, the connection becomes unusable  
for subsequent queries.
--
kobi


On Dec 22, 2006, at 5:45 AM, Dan Pascu wrote:

> On Friday 22 December 2006 10:47, Kobi Eshun wrote:
>> By the way, I found out by accident that if a stored procedure does
>> not return any result set, that the existing API works just fine (at
>> least so far).
>
> Without any changes (except the CLIENT_MULTI_RESULTS flag), the  
> current
> implementation works just fine as long as the stored procedure  
> returns 0
> or at most 1 result sets. The trouble starts with more than 1  
> result set.
>
> -- 
> Dan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://openser.org/pipermail/devel/attachments/20061222/4d25982f/attachment.html