Stored Procedures

[eluser]coolant[/eluser]
I am trying to use stored procedures and CI together. When I call the command through terminal, I get the result

Code:

mysql> call moo();
+-----------+
|   user_id |
+-----------+
|         1 |
+-----------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

But when I run this

Code:

$query = $this->db->query('call moo();');
print_r ( $query->result_array( ) );

I get the following error

<h1>A Database Error Occurred</h1>
<p>Error Number: 1312</p><p>PROCEDURE users.moo can't return a result set in the given context</p><p>call moo();</p>

Any ideas how to fix this?

Thanks!

[eluser]coolant[/eluser]
Changed from mysql to mysqli = problems over.