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')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')Stored Procedures in Laravel
DB::connection("sqlsrv")->statement('exec Pro_Internal_Transfer_Note_post @mvoucherid='.$VMID);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?Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
