How can I include a procedure in my Eloquent ORM laravel select?

Question

How can I include a procedure in my Eloquent ORM select laravel?

I would like to call my procedure call pro_get_products_in_stock(0) function inside my select, as in the block below:

 $list = Product::query()->select(DB::raw('call pro_get_products_in_stock(0)'))->get();

Does anyone know how to do this?

score 1 · Accepted Answer · answered Nov 22 '21 at 18:57

1

You can't use Eloquent for this operation.

What you can use is the Query builder.

$query = DB::select('call pro_get_products_in_stock(?)', [0]);
$result = collect($query);

Note, I have not tested it yet, this answer is based on an article of Medium and a SO answer.

answered Nov 22 '21 at 18:57

Samuel Ferdary

OK thank you. I thought it was possible. I had to do without the procedure. – Danilobol Nov 23 '21 at 04:00

1 Answers1