/PHP/How to use stored procedure in laravel

How to use stored procedure in laravel

DB::select('exec my_stored_procedure("Param1", "param2",..)');
or

DB::select('exec my_stored_procedure(?,?,..)',array($Param1,$param2));
Try this for without parameters

DB::select('EXEC my_stored_procedure')

Source: stackoverflow.com

Stored Procedures in Laravel

DB::connection("sqlsrv")->statement('exec Pro_Internal_Transfer_Note_post @mvoucherid='.$VMID);

Source: stackoverflow.com

Similar codes

12 votes100 views3 answers
Update composer php version
PHP
39 votes87 views4 answers
Php artisan make:controller --resource command
PHP
0 vote122 views1 answer
Laravel latest from relationship
PHP Laravel
1 vote129 views3 answers
Laravel eloquent where date today
PHP Laravel
-1 vote86 views1 answer
Laravel 7 generator
PHP
1 vote107 views1 answer
Invalid datetime format laravel
PHP
1 vote110 views2 answers
Set nav link active on the basis of route laravel 8
PHP Laravel
5 votes97 views2 answers
Laravel migration price
PHP
0 vote96 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP
3 votes88 views2 answers
How to assign value of a js variable to a php variable
PHP