0
I’m making a select in a procedure, but I can’t page because the result returns array:
DB::select('EXEC PR_MONITORAMENTO @FUNCAO="S2", @ID_CD_INTERNACAO='.$ID_INTERNACAO.',
@ID_CD_CONVENIO='.$ID_CONVENIO.',@NM_PESSOA= '.$NM_PESSOA.'');
And when I do a db::raw it returns an object with the name
DB::raw('EXEC PR_MONITORAMENTO @FUNCAO="S2", @ID_CD_INTERNACAO='.$ID_INTERNACAO.',
@ID_CD_CONVENIO='.$ID_CONVENIO.',@NM_PESSOA= '.$NM_PESSOA.'');
object(Illuminate\Database\Query\Expression)#290 (1)
{
["value":protected]=> string(95)
"EXEC PR_MONITORAMENTO @FUNCAO="S2", @ID_CD_INTERNACAO=,
@ID_CD_CONVENIO=,@NM_PESSOA= "
}
I want to do the select in that procedure and page, any hint?
You have to page your
Stored Procedureand withDB::selectit’s not really going to work out, because your logic is inStored Procedure. Now if it were a Vision (View) you could do what you need!– novic
In case I would have to do that select from stored Process within the view right? but that would escape from the good practices? I thank you from already
– André Tripode Colognesi
In case you should only do the
View!!!– novic