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

[SourceForge.net]

Bugs item #1618322, was opened at 2006-12-18 20:17
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1618322&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver 1.1.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: vabdulla (vabdulla)
Assigned to: Nobody/Anonymous (nobody)
Summary: avp_db_query cannot call mysql stored procedures

Initial Comment:
Hi,

When calling a mysql5 stored procedure which returns a result set like this:
avp_db_query("CALL db.sp_name('$avp(s:param1)', "param2",'$oU')", "$avp(s:rs1);$avp(s:rs2));

I get the following error:

0(1245) submit_query: PROCEDURE db.sp_name can't return a result set in the given context
0(1245) db_raw_query: Error while submitting query
0(1245) avpops:db_query_avp: error - cannot do the query

After some research, I have found that this error come from the client flags passed to mysql_real_connect() function.

The patch attached correct this bug.

-- 
Regards,
-vma
.



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1618322&group_id=139143