Multiple queries in code igniter - semicolon breaks query

[eluser]petkodil[/eluser]
Thanks for the suggestion. I had no experience with stored procedures, but after some reading seems like this could be my thing.
I have one other problem now - I created a test stored procedure but I can not invoke it and get its result using the suggested method $this->db->call_function('test_procedure');

I get this error:
db_error_heading
This feature is not available for the database you are using.

I guess I am missing something. I came across this thread that has some suggestions:
http://ellislab.com/forums/viewthread/71141/ but am not sure if I should stick to the call_function method or try any of those.

Thanks!