CodeIgniter Forums
CI 3.1.2 + PDO stored procedures issue - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: Issues (https://forum.codeigniter.com/forumdisplay.php?fid=19)
+--- Thread: CI 3.1.2 + PDO stored procedures issue (/showthread.php?tid=66942)



CI 3.1.2 + PDO stored procedures issue - grego - 12-21-2016

Hello All,
I found another big issue. I can not get result of stored procedure. When I call stored procedure I have no return any values but procedure return value. I use CI 3.1.2 PDO driver for mssql server. Does any know how to fix it?


RE: CI 3.1.2 + PDO stored procedures issue - prashant.nirgun - 01-23-2017

same

Error Number: HY000/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.
CALL get_user_login_sp('xxx')
Filename: models/Login_model.php
Line Number: 54