How to run stored procedures in Laravel 5.5?

Question

I have already tried:
return \DB::select('EXEC notes');
return \DB::select('CALL notes');

The errors I get when running the above code is:
Packets out of order. Expected 1 received 18. Packet size=101 (SQL: CALL notes())

I did a query:
SELECT @@global.max_allowed_packet
And it returned 1073741824

Increasing the max_allowed_packet did not solved the problem.

Is there any other way?

Did you try https://stackoverflow.com/a/23741694/4848587? How to set the attribute in Laravel: http://fideloper.com/laravel-pdo-connection-options — Jonas Staudenmeir, Apr 18 '18 at 14:36
the thing is, I don't know how to use that @JonasStaudenmeir — , Apr 19 '18 at 01:52
What's unclear to you? Take a look at the second link's last code example. — Jonas Staudenmeir, Apr 19 '18 at 03:00

score 0 · Accepted Answer · answered Nov 06 '18 at 03:28

0

$notes = DB::select(
    'call notes'
);

answered Nov 06 '18 at 03:28

1 Answers1