pl/sql parameter is null sometimes
i have this sp
PROCEDURE MostrarVisitaDetalle
(k_fecha_reg in varchar2,
k_visnrodoc in varchar2,
.
.
.
FROM xx.ACME vs
where vs.visfecreg >= to_date(k_fecha_reg, 'DD/MM/YYYY')
and vs.visfecreg < to_date(k_fecha_reg, 'DD/MM/YYYY') + 1
and vs.visnrodoc = k_visnrodoc
As I should modify the code in the where, since the parameter is sometimes NULL
PROCEDURE MostrarVisitaDetalle
(k_fecha_reg in varchar2,
k_visnrodoc in varchar2,
.
.
.
FROM xx.ACME vs
where vs.visfecreg >= to_date(k_fecha_reg, 'DD/MM/YYYY')
and vs.visfecreg < to_date(k_fecha_reg, 'DD/MM/YYYY') + 1
and vs.visnrodoc = k_visnrodoc
As I should modify the code in the where, since the parameter is sometimes NULL
Thanks for using Experts Exchange.
Please provide your email to receive a sample view!
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.