Hello
Good afternoon friends.
I have a problem, a cursor when it does not bring data, does not enter the exception no_data_found, proving an error when continuing. the error is given here in this query.
the exception does not work: "no_data_found"
s
BEGIN
OPEN RC1 FOR
select tisi_codigo
FROM SIN_CERTIFICADO_DEUDA SCD,
SIN_CERTIFICADO_CUOTAS SCC,
SIN_SINIESTRO SS,
PRD_ITMPOLIZA PI,
VTA_PERSONAID VPI,
VTA_PERSONA VP,
ADM_ESTADO AE,
PRD_POLIZA PP
WHERE SCD.SIN_CERTIFICADO_ID = SCC.CERTIFICADO_ID
AND SCD.SIN_CERTIFICADO_ID = SS.SIN_CERTIFICADO_ID
AND SS.POLI_CODIGO = PI.POLI_CODIGO
AND VP.PERS_RUT = PI.PERS_RUTASEG
and SCC.ESTADO_CUOTA = AE.ESTA_CODIGO
AND SS.POLI_CODIGO = PP.POLI_CODIGO
AND SS.TISI_CODIGO = p_tisi
AND AE.ESTA_CODIGO = 2010 --PAGADOS--
AND VPI.ID_PERSONA = '96837640-3' --p_rut
AND VPI.PERS_RUT = VP.PERS_RUT;
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_GlsError := NULL;
v_GlsError := SUBSTR(SQLERRM, 1, 200);
OPEN RC1 FOR
SELECT -1 Solicitud,
'No Hay Datos Para Esta consulta' || v_GlsError
FROM DUAL;
RETURN;
WHEN OTHERS THEN
v_GlsError := SUBSTR(SQLERRM, 1, 200);
OPEN RC1 FOR
SELECT -2 Solicitud,
'Error Consulta Cliente:' || v_GlsError
FROM DUAL;
RETURN;
END;