Stored Procedure not working

Try it like this and see if it works, not tested.

PHP Code:

$foo_sql = $this->db->query("call getFooData('{$foo_id}', '{$fooname}');"); 


For one you are missing the procedure semi-colon.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )