Problems with Stored Procedures in Laravel 5.6?

0

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?

    
asked by anonymous 30.07.2018 / 16:27

0 answers