How to execute Stored Procedure from Laravel

by

Try something like this

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')

More Related Contents:

  1. Laravel 5 – redirect to HTTPS
  2. Laravel : Syntax error or access violation: 1055 Error
  3. How to validate array in Laravel?
  4. Access Controller method from another controller in Laravel 5
  5. What is the difference between find(), findOrFail(), first(), firstOrFail(), get(), list(), toArray()
  6. Can’t install laravel installer via composer
  7. Laravel: validate an integer field that needs to be greater than another
  8. Laravel Request::all() Should Not Be Called Statically
  9. Handling expired token in Laravel
  10. Laravel 5 not finding css files
  11. Laravel catch TokenMismatchException
  12. Why do I have to run “composer dump-autoload” command to make migrations work in laravel?
  13. How to select all column name from a table in laravel?
  14. Laravel 5 hasMany relationship on two columns
  15. Laravel 5.2 Auth not Working
  16. Call to undefined method Maatwebsite\Excel\Excel::load()
  17. Laravel 5 – Clear Cache in Shared Hosting Server
  18. Laravel 5 change public_path()
  19. ErrorBag is always empty in Laravel 5.2
  20. Laravel 5.2 not reading env file
  21. Fatal error: Class ‘Illuminate\Foundation\Application’ not found
  22. disable csrf in laravel for specific route
  23. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  24. Custom validator in Laravel 5
  25. laravel 5 : Class ‘input’ not found
  26. Class ‘App\Http\Controllers\DB’ not found and I also cannot use a new Model
  27. Get Return Value from SQL Stored Procedure using PHP
  28. How to remove /public/ from a Laravel URL
  29. Merge ‘with’ and ‘whereHas’ in Laravel 5
  30. Unit Test Laravel’s FormRequest

Leave a Comment