Call 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

Call stored procedure in laravel

Hi
I have something to ask

ADMIN_USER PROCEDURE HAVE THREE INPUT PARAMETER AND ONE OUTPUT PARAMETER
(INPUT PARAMETER) I_ADMIN_ID, I_PWD, I_CONN_IP
(OUTPUT PARAMETER) O_RET_CD

(PHP CODE)
DB::select('EXEC dbo.ADMIN_USER @I_ADMIN_ID = ?, @I_PWD = ?, @I_CONN_IP = ?',[$credentials['user_id'], $credentials['password'], $_SERVER['REMOTE_ADDR']]);

How can I get the output parameters passed?

Similar codes

0 vote258 views1 answer
Wordpress change language of specific text php
PHP
60 votes235 views3 answers
Only display part of string php
PHP
13 votes198 views4 answers
Php get domain from url
PHP
0 vote176 views1 answer
Woocommerce Display field value on the admin order edit page [Custom Field Display 2]
PHP
0 vote193 views1 answer
Die laravel
PHP
1 vote191 views1 answer
Fixuphost
PHP
0 vote255 views1 answer
Laravel with callback
PHP
13 votes253 views6 answers
How to run laravel project
PHP
0 vote228 views1 answer
Intl extension php ubuntu
PHP
0 vote231 views1 answer
Drupal 9 how to render a view block from render array with arguments
PHP Drupal