Saturday, April 15, 2017

Laravel: Return multiple datasets in DB::select

I have a stored procedure which returns multiple datasets (basically there are two select statements in the stored procedure). But DB::select only takes in the first data set returned by the query. I'm calling me stored procedure the following way:

$query = 'EXEC [dbo].[myStoredProcedure] \''. $param . '\'';
$result = DB::select($query);

I'm using Laravel 5.1

Please let me know what exact function to use instead of DB::select. Thanks in advance.



via Flemin Adambukulam

Advertisement