stored procedure in codeigniter code example
Example: call procedure in codeigniter
$query = $this->db->query("CALL getUserDetails(?,?)",array('departmentId'=>'1','userId'=>='10010'));
$data = $query->result();
$query = $this->db->query("CALL getUserDetails(?,?)",array('departmentId'=>'1','userId'=>='10010'));
$data = $query->result();