Skip to content

Instantly share code, notes, and snippets.

@edumelzer

edumelzer/resolver_no_dt_found_regra_calculo.sql

Created May 16, 2014 17:35
Show Gist options
  • Save edumelzer/832746d553bc18bf091f to your computer and use it in GitHub Desktop.
Save edumelzer/832746d553bc18bf091f to your computer and use it in GitHub Desktop.
Download ZIP
Resolvendo no_data_found em Regras de cálculo após mudança na inicialização de pagamentos.
Raw
resolver_no_dt_found_regra_calculo.sql
...
while vcod_pagamento <= 999 loop
--
begin
--
ps_var.valor_pagamento(vcod_pagamento) := ps_var.valor_pagamento(vcod_pagamento);
--
exception when no_data_found then
--
ps_var.valor_pagamento(vcod_pagamento) := 0;
--
end;
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment