_Alex_SMIRNOV_ |
покажите что у вас в SQLsource? |
declare
p_sum number default 0;
p_sum_ret number default 0;
DATA1 ob_pkg.R_HUMAN_DATA;
DATA2 ob_pkg.r_AccountDataCalc;
begin
DATA1.id := :g_oid;
DATA1.filed1 := :g_param1;
DATA1.filed2 := :g_param2;
DATA1.filed3 := :g_param3;
DATA1.filed4 := :g_param4;
DATA1.filed5 := :g_param5;
DATA2.id := :dt_oid;
DATA2.parent := :dt_param1;
DATA2.filed1 := :dt_param2;
DATA2.filed2 := :dt_param3;
DATA2.filed3 := :dt_param4;
DATA2.filed4 := :dt_param5;
DATA2.filed5 := :dt_param6;
DATA2.filed6 := :dt_param7;
begin
p_sum := ((DATA2.filed3 * 5) / DATA1.filed2) * DATA1.filed3;
exception
when others then null;
end;
:Suma_pay := p_sum;
:Suma_ret := p_sum_ret;
end;