Hi, is it possible to update with a stored procedure and how ??
ex :
=============================================
PROCEDURE UPDATE_VIEW_PARAMETER_BO
(I_date_deb in DATE,
I_date_fin in DATE/
)
is
BEGIN
update dba.view_parameter
set
date_fin = I_date_fin,
date_debut = I_date_deb
where
mandant = 'RTF' and
queue_name = 'RTF_INDIC_GEN_HEB' and
username = 'GUIFFROYMA'
;
commit;
END;
================================================
but because there is data found, it doesn't work ...
Thanks
ex :
=============================================
PROCEDURE UPDATE_VIEW_PARAMETER_BO
(I_date_deb in DATE,
I_date_fin in DATE/
)
is
BEGIN
update dba.view_parameter
set
date_fin = I_date_fin,
date_debut = I_date_deb
where
mandant = 'RTF' and
queue_name = 'RTF_INDIC_GEN_HEB' and
username = 'GUIFFROYMA'
;
commit;
END;
================================================
but because there is data found, it doesn't work ...
Thanks