Hi All,
Am having a problem where this code in a DA is changing the value of a page item that ts not supposed to be changed
This is the PL/SQL Cdoe
declare
l_prima number;
l_derrama number;
begin
begin
select
nullif(r.derrama,0)
into
l_derrama
from
risk_riesgos r
where
r.riesgo_id = (select p.riesgo_id from risk_polizas p where p.poliza_id = :P33_POLIZA_ID) ;
exception
when no_data_found
then
l_derrama := 0.00;
end;
if l_derrama != 0.00 then
l_prima := to_number(replace(:P33_PRIMA,',',''));
:P33_DERRAMA := to_char(l_prima * l_derrama);
else
:P33_DERRAMA := to_char(l_derrama);
end if;
end;
The ITEMS TO SUBMIT are P33_PRIMA,P33_POLIZA_ID
The ITEMs TO RETURN is P33_DERRAMA
For some reason the P33_PRIMA is getting null or 0 when is not an item to return.
Is something wrong with this code?
Thanks for the help!