execute mysql stored procedures with CodeIgniter

[eluser]Unknown[/eluser]
[quote author="boltoncole" date="1261099094"]I tried these codes, but I'm unable to make it work
Can someone help me? >.<[/quote]


I'm not passing in any parameters, but I have successfully called a proc this way.

Code:

$sql = "CALL my_stored_proc()";
$this->db->query($sql);

I would imagine that the parameters would need to be passed in like this (with single quotes if the params are strings).

Code:

$sql = "CALL my_stored_proc(".$param1.", ".$param2.")";
$this->db->query($sql);

I'm using the mysql driver - not the mysqli driver.