Calling a stored procedure from Magento

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);

$resource = Mage::getSingleton('core/resource');

$readConnection = $resource->getConnection('core_read');

$query = 'CALL stored_procedure()';

$results = $readConnection->exec($query);

Calling a stored procedure from Magento

Need help implementing this solution, or still looking for a fix to your Magento problem? Get in touch and I will be happy to help with your project.

Tags: SQL

The Magento Expert

Independent Magento developer & consultant

Calling a stored procedure from Magento