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 |