Call to a Member Function result() on bool

Question

I’m trying to get results from a Stored Procedure in the CodeIgniter, in the bank brings the result normally but in the CodeIgniter brings that mistake:

in my model is like this:

public function totalPassagens(array $array)
{
    $sql = "SET NOCOUNT ON exec whRelOSTotalizarResultadoAgendamento 3562, ?, ?, ?";
    $query = $this->db->query($sql);
    return $query->result();
}

and in my controller just to go out I did so:

$result = $this->posvendas->totalPassagens([getCodeLocal($local), 
      date('Y-m-01 00:00:00'), 
      date('Y-m-d 23:59:59')]); // Não esta retornando a consulta
echo '<prev>';
print_r($result);

If I take SET NOCOUNT ON from the front of the exec it does not from the error but does not bring me the expected result but an empty array, then I tested it in any file with the query sequinte :

try {
      $Conexao    = ConexaoTS::getConnection();
      $infoQuery  = $Conexao->query("SET NOCOUNT ON  EXEC 
       whRelOSTotalizarResultadoAgendamento 
       @CodigoEmpresa=3562, @CodigoLocal= ?, @DaDataAgenda= ?, 
     @AteDataAgenda= ?");
      
      $info       = $infoQuery->fetchAll();
    } catch (Exception $e) {
    
      echo $e->getMessage();
      exit;
    }
    
echo '<prev>';
print_r($info);

I did exactly the same query and the result was this :

I mean, it brought the results, but in CodeIgniter brings me nothing, I tried to put result_array(), get(), result() but I’m taking the same error.