Hi,
Am trying to select between two values from two different tables. If the value of PORC in table RISK_PRODUCTOR is 0 or null
I check the value in PORCIENTO in table RISK_RIESGOS_PRODUCTORES and use that instead if exist. If not I will assign null.
But am getting this error in this code:
declare
l_porc_productor number;
l_com_productor number;
begin
select
nullif(porc,0)
into
l_porc_productor
from
risk_productor p
where
p.productor_id = :p42_productor_id
and r.organizacion_id = :APP_GET_ORGANIZACION_ID;
exception
when no_data_found
then
l_porc_productor := null;
if l_porc_productor is not null then
:P42_PORC_PRODUCTOR := l_porc_productor;
else
select
nullif(porciento, 0)
,nvl2(nullif(porciento, 0), null, cantidad)
into
:p42_PORC_PRODUCTOR
,:p42_COM_PRODUCTOR
from
risk_riesgos_productores r
where
r.agencia_id = :p42_agencia_id
and r.compania_id = :p42_compania_id
and r.riesgo_id = :p42_riesgo_id
and r.productor_id = :p42_productor_id
and nvl(:P42_PORC_PRODUCTOR,'0') = 0
and r.organizacion_id = :APP_GET_ORGANIZACION_ID;
ORA-06550: line 43, column 6: PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following: ( begin case declare end exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge json_exists json_value json_query json_object json_array
exception
when no_data_found
then
:p42_porc_productor := null;
:p42_com_productor := null;
end if;
end;
What am missing here?
Thanks for any help!!!