View with store Procedure, mysql

Question

I have a procedure correct and a view which uses the Procedure parameter, only the view does not see the Procedure parameter, how to do to solve this problem?

Create a store So that from the customer’s code you can get the total amount of purchases with a discount of 10%

delimiter $$
drop view if exists visao  $$
create view visao as select n.cod_cliente as codCli, (sum(i.qtd_vedida * i.pco_recebido)*0.9) as valorTotal
        from nota_fiscal as n, item_nota_fiscal as i
        where n.numero_nf = i.numero_nf and n.cod_cliente = AQUI SERIA O PARÂMETRO DA PROCEDURE, SÓ QUE A PROCEDURE VEM DEPOIS E ELE NÃO CONSEGUE PEGAR O PARÂMETRO, EXISTE ALGUMA SOLUÇÃO??(pCodCli )
        group by codCli $$

DROP PROCEDURE IF EXISTS uspDesconto $$
CREATE PROCEDURE uspDesconto (pCodCli int(11))

BEGIN
  DECLARE done BOOLEAN DEFAULT FALSE;
  DECLARE vCodCli, vQtd_vedida int(11);  
  DECLARE vValorTotal decimal(10,2);
  DECLARE cont integer;

  declare cursor_a cursor for  select * from visao;

  DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = TRUE;
  set cont = 0;

  DROP TEMPORARY TABLE IF EXISTS tmp_Prod_Forn;
  CREATE TEMPORARY TABLE tmp_Prod_Forn (
        tmpCodCli int(11),
        tmpValorTotal decimal(10,2)
  );

  OPEN cursor_a;
  REPEAT FETCH cursor_a INTO vCodCli, vValorTotal;
     IF NOT done THEN
        insert into tmp_Prod_Forn values(vCodCli, vValorTotal);
        -- set cont = cont + 1;
     END IF;

  UNTIL (done) END REPEAT;
  close cursor_a;

  SELECT * FROM tmp_Prod_Forn;
END $$

delimiter ;

Answer 1

Knowing that a view is the same as a table, as I explained in answer to your previous question the only thing you need to do is use this parameter as a filter for the query in the view, so when creating the cursor, simply use the Where parameter of the query in the view:

declare cursor_a cursor for  select * from visao where codCli = pCodCli;

EDIT

Seeing your edition I realized where the code of the parameter is.

Your view should then be created as follows:

create view visao as 
    select n.cod_cliente as codCli, 
          (sum(i.qtd_vedida * i.pco_recebido)*0.9) as valorTotal
      from nota_fiscal as n, 
           item_nota_fiscal as i
     where n.numero_nf = i.numero_nf 
     group by codCli $$

No need Add the parameter directly in the view, this view will work as a table that will have the following format:

"Tabela" visao
  codCli
  valorTotal     

So all you need to do is use the field codCli which is the same field n.cod_cliente that you were trying to use. What you’re doing here is putting the filter to be used outside the view. So just use the view as reported before here:

declare cursor_a cursor for  select * from visao where codCli = pCodCli;