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

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!

Keywords: SQL

★★★ The Magento Expert ★★★

Magento Professional with 27080 hours project experience

Calling a stored procedure from Magento