Hey guys,
Since upgrading my Zend Framework from 1.7 to 1.8, I've started getting an
error when trying to execute a stored procedure.
My PHP install is on Ubuntu,
PHP 5.2.4-2ubuntu5.5 with Suhosin-Patch 0.9.6.2 (cli) (built: Feb 11 2009
20:09:52)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with Xdebug v2.0.3, Copyright (c) 2002-2007, by Derick Rethans
And I've seen the bug: http://bugs.php.net/bug.php?id=42548
However, when I switch back to 1.7 from 1.8, I get the desired results.
$ret = $db->query("CALL my_proc(?)", $id);
$data = $ret->fetch(); // get the row from the result set
$ret->closeCursor(); // clean up after ourselves so we don't get a
mysqli error
In this code, $db is a Zend_Db_Adapter_Mysqli, from which all other queries
work. The error I'm receiving is:
Mysqli statement execute error : PROCEDURE my_proc can't return a result set
in the given context
Is there anything I should do with the mysqli object to avoid this? Can I
set some server options with mysql option multi statements?
Thanks,
- matt hoopes
