+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: A Database Error Occurred : unable to run the stored procedure (/showthread.php?tid=48013)
A Database Error Occurred : unable to run the stored procedure - El Forum - 01-01-2012
[eluser]Unknown[/eluser]
Hi all,
I'm new to CI and start exploring all the features now. However, i have been stuck with a database select operation using stored procedure.
Here is the model class that i have
class SignUp_model extends CI_Model{
function __construct()
{
parent::__construct();
}
function GetLognProfile(){
$sql = "call usp_GetLoginUserProfile()";
$this->db->query($sql);
}
}
I could execute the SP in mysql window and get to see the result. However when i run the page am getting following message
A Database Error Occurred
Error Number: 1312
PROCEDURE logindb.usp_GetLoginUserProfile can't return a result set in the given context
call usp_GetLoginUserProfile()
Filename: C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\LoginSystem\system\database\DB_driver.php
Line Number: 330
Can some one help me please??