Using the code below you can call a stored procedure directly from Magento.
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$query = 'CALL stored_procedure()';
$results = $readConnection->exec($query);
Calling a stored procedure from Magento
You want or need help implementing this solution? Maybe you did not find what you were looking for? Contact me and I will assist you with whatever Magento problem troubles you!