1
I have a problem and a doubt at the same time, I made a function to see invoiced orders and declared a function variable so:
select filsaida
into v_loja
from mov_itped where pedido= p_pedido and status <> 6;
end ;
When you have some record that matches the clause WHERE
, the function returns normal, but when it does not return record, gives the error ORA-01403: data not found.
Could you put the function? Or the statement and part of the
return
?– David