SPs do need special permissions on server, which most shared providers do not give. I went to a VPS-account for my heavily SP-based project. Btw, check the MySQL version also. If all is fine you do a "CALL pName(x, y, z);" trough SQL...