Stored Procedure PHP

StoredProcController.php

<?php

namespace App\Http\Controllers;


use App\Model\Notification;
use App\Abstracts\Controllers\ApiController;
use Doctrine\DBAL\Driver\PDOConnection;
use Illuminate\Http\Request;

class StoredProcController extends ApiController
{
    public function start(Request $request) {
        $db = \DB::connection()->getPdo();
        $db->setAttribute(PDOConnection::ATTR_ERRMODE, PDOConnection::ERRMODE_EXCEPTION);
        $db->setAttribute(PDOConnection::ATTR_EMULATE_PREPARES, true);
        $res = $db->prepare('CALL getAllNotifications()');
        $res->execute();
        $data = $res->fetchAll(PDOConnection::FETCH_ASSOC);
        $res->closeCursor();
        return $data;

    }
}