I have gone through lots of post from StackOverflow and other sites. Following is the solution which I found almost on all sites :-

 return new \Phalcon\Db\Adapter\Pdo\MySql(array(
        "host"     => 'tams2.creativecounsel.co.za',
        "username" => 'portal_netwin',
        "password" => 'c00lb4n4nas',
        "dbname"   => 'creative',
        "options"  => array(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true)
    ));

But its not working for me.

My code for calling Store Procedures:

public function AssignPromoterToPromotionVenuAction($bookingSheetID = 0, $promoter_id = 0, $userID = 0)
{
    $query = "CALL `x_wf_AgencyAssignPromoter`($bookingSheetID, $promoter_id, $userID)";
    $rp = new Promotion();
    return new Resultset(null, $rp, $rp->getReadConnection()->query($query));
}

public function RemovePromoterToPromotionVenuAction($bookingSheetID = 0, $promoter_id = 0, $userID = 0)
{
    $query = "CALL `x_wf_AgencyRemovePromoter`($bookingSheetID, $promoter_id, $userID)";      
    $rp = new Promotion();
    return new Resultset(null, $rp, $rp->getReadConnection()->query($query));
}