execute mysql stored procedures with CodeIgniter

[eluser]MadZad[/eluser]
We're on MySQL 5.0.27, CI 1.6.1 and my stored proc call just looks like this:

Code:

$sql = "CALL my_stored_proc(?)";
$params = array($only_input);
$this->my_db->query($sql, $params);
return ($this->my_db->affected_rows() == 1);

Now, this is a simplistic version because I have no need for return values, and this is my first time using SPs, so I'm not exactly a fountain of information. But it is clearly possible, so keep trying.