How to Run the Laravel Stored Procedure
source link: https://www.codesd.com/item/how-to-run-the-laravel-stored-procedure.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
How to Run the Laravel Stored Procedure
I need to execute a stored procedure after my form submits data. I have the stored procedure working like I want it, and I have my form working properly. I just do not know the statement to execute the sp from laravel 5.
it should be something like this: execute my_stored_procedure. but I can not seem to find anything like that online.
Try something like this
DB::select('exec my_stored_procedure("Param1", "param2",..)');
DB::select('exec my_stored_procedure(?,?,..)',array($Param1,$param2));
Try this for without parameters
DB::select('EXEC my_stored_procedure')
Related Articles
Msg 6522, Level 16 Alarm When Running the Clr Stored Procedure
How to reuse the same stored procedure for more details and summary
how to display the complete stored procedure code?
How to Run a Looped Stored Procedure
How to profile the CLR stored procedure
How to call the Oracle stored procedure that returns the ref cursor
Run the Oracle stored procedure from .NET
Converting the DateTime Error When Running the SQL Stored Procedure
Get the result of the Laravel stored procedure
Trouble Running the SQL Stored Procedure from C #
How to call the parameterized stored procedure for each row in a table without using the cursor
Run the SQL stored procedure with the textBox value error in C #
Run the SQL stored procedure in ASP Classic
How to call the SQL stored procedure purely dynamically (dynamic parameters in sp_executesql)?
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK