bcit-ci/CodeIgniter#495

StoredProcedure.sql

CREATE DEFINER=`user`@`localhost` PROCEDURE `test`()
BEGIN 
SELECT * FROM users; 
END

testmodel.php

<?php

/**
 * application/models/testmodel.php
 *
 */

class Testmodel extends CI_Model {

	public function __construct(){
		parent::__construct();
	}

	public function test(){
		$query = $this->db->query("CALL test");
		return $query->result();
	}

}

welcome.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

/**
 * application/controllers/welcome.php
 *
 */

class Welcome extends CI_Controller {


	public function index()
	{
		$this->load->model('Testmodel');
		$this->Testmodel->test();
		$this->load->view('welcome_message');
	}
}