如何在phalcon中执行oracle过程

// 配置数据库连接
$di->set('db', function () {
    return new \Phalcon\Db\Adapter\Pdo\Oracle([
        'host'     => 'localhost',
        'username' => 'your_username',
        'password' => 'your_password',
        'dbname'   => 'your_database',
    ]);
});

// 创建Model类
class YourModel extends \Phalcon\Mvc\Model
{
    // 定义执行Oracle过程的方法
    public function executeOracleProcedure($param1, $param2)
    {
        $sql = "BEGIN your_procedure(:param1, :param2); END;";
        $params = [
            'param1' => $param1,
            'param2' => $param2,
        ];
        
        $this->getDi()->get('db')->execute($sql, $params);
    }
}

// 调用执行Oracle过程的方法
$model = new YourModel();
$model->executeOracleProcedure($param1, $param2);