I am making a select
in a procedure
, but I can not 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 named
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 select
on this procedure
and page , any tips?