One connection for many MySQL Stored Procedures

[eluser]Unknown[/eluser]
I've noticed people have had some problems with using one connection for multiple stored procedures. Has this been resolved by CI? Should I stick to using one connection per stored procedure or can I safely use this in one db->query call? I was worried about having to call a stored procedure many time for a batch insert now it's looking like I can't even limit the overhead to one connection >.>

Code:

foreach($foo as $bar) {
  $params = array($bar, $ram, $sheep);
  $this->db->query("CALL ins_foo(?, ?, ?)", $params);
}