How to call storedprocedure in codeigniter

See more:

MySQL

CodeIgniter

Dear Friends,

I have stored procedure name 'chef_allproducts'. It shows an error:

Can't reopen table: 'ci' call chef_allProducts()

What I have tried:

i have tried this in codeigniter below:

Modal:
$query = $this->db->query("CALL chef_allProducts()");
return $query->result();

Controller:
$data['field'] = $this->Excelex->get_field();
$this->load->view('excel', $data);

View:
foreach($field as $f):
echo $f;
endforeach;