Problem with cursor in Mysql

Question

Good afternoon!

I am successfully creating the following cursor:

declare v_cursor cursor for
    select idCliente, max(dataVenda) from Cliente
    left join Venda on idCliente = cliente_idCliente
    group by idCliente;

But when executing the command fetch I get the following error:

Error code 1329, SQL state 02000: No date - zero fetched Rows, Selected, or processed

Apparently he accuses the select did not return any tuple to the cursor. However, when I execute the select isolated, it returns data:

Can anyone tell me why this happens?

There is a way around this problem?

Thank you!

Answer 1

Missing the HANDLER statement:

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

Source: https://stackoverflow.com/a/23690018/194717