Zend FrameWok中调用mysql的存储过程

在Zend FrameWork中调用mysql的存储过程方法如下：

$db = Zend_Db::factory($sql_DbType,$sql_Config);
$connection=$db->getConnection();

Zend_Registry::set("db",$db);
Zend_Registry::set("connect",$connection);

 

调用存储过程如下代码所示：

$this->_db = Zend_Registry::get('db');
$connection=Zend_Registry::get("connect");
$connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);
$prev_next_rs=$this->_db->query('call moretableSelect();')->fetchAll();