Hi,
Using the code you provided in the original post I would try changing the calls to the stored procedure this way:
PHP Code:
$stmt=$this->db->prepare("call sp1(?)");
$stmt->execute(array($param1));
$stmt->fetchAll();
$stmt->closeCursor();
if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
$this->dbObj->closeConnection();
}
then try to call the sp again.
What does $this refer to in your code? Where are you trying to make this call from? In the above I assume that $this->db gets you a Zend_Db_Adapter_Abstract object.
Hope this helps,
Brian