php - CakePHP 中的存储过程错误

Question

知道如何在 CakePHP 中调用存储过程吗？

$results = $this->query('call p2');
echo $results;

虽然我一直收到这个错误:

Error: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered 
queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code 
is only ever going to run against mysql, you may enable query buffering by setting the 
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.

Answer 1

我在事务中完成了此操作，以确保其间不会调用该过程的其他实例:

$this->begin();
$this->query("CALL procedure();");
$result = $this->query("SELECT something");
$this->commit();

您的问题可能是您正在调用:

$this->query('call p2');

你应该打电话的地方:

$this->query('call p2()');

因为过程很像函数。