显示从laravel调用的sql server存储过程中的数据时出错。

'mssql' => [
    'driver' => 'sqlsrv',
    'host' => env('DB_HOST', 'localhost'),
    'port' => env('DB_PORT', '1433'),
    'database' => env('DB_DATABASE', 'forge'),
    'username' => env('DB_USERNAME', 'forge'),
    'password' => env('DB_PASSWORD', ''),
    'charset' => 'utf8',
    'prefix' => '',
],

use Illuminate\Support\Facades\DB;

$result = DB::select('EXEC your_stored_procedure_name @param1=?, @param2=?', [$param1, $param2]);

try {
    $result = DB::select('EXEC your_stored_procedure_name @param1=?, @param2=?', [$param1, $param2]);
} catch (\Exception $e) {
    // 处理错误
    Log::error('Error executing stored procedure: ' . $e->getMessage());
}

CREATE PROCEDURE GetUsers
    @userId INT
AS
BEGIN
    SELECT * FROM users WHERE id = @userId;
END

use Illuminate\Support\Facades\DB;

try {
    $userId = 1;
    $result = DB::select('EXEC GetUsers @userId=?', [$userId]);
    // 处理结果
    foreach ($result as $user) {
        echo $user->name . '<br>';
    }
} catch (\Exception $e) {
    // 处理错误
    Log::error('Error executing stored procedure: ' . $e->getMessage());
}