Problem in dropping procedure
Posted in 2007
Hi All,
We are using IDS version 10.00.UC5 and facing a problem in dropping a procedure. Two procedures were created by mistake with same name i.e. pdc_card_lmt_upd but with different number of parameters as:
CREATE PROCEDURE pdc_card_lmt_upd
(
lcard_no varchar(19),
lnew_fdy_lmt float,
lnew_fwk_lmt float,
lnew_mth_lmt float,
lstatus char(3),
laction char(20),
luser_id char(15)
)
CREATE PROCEDURE pdc_card_lmt_upd
(
lacc_no varchar(19),
lnew_crd_lmt float,
lacc_status char(1),
laction char(20),
luser_id char(15)
)When we are trying to drop the procedure, facing following error:
drop procedure pdc_card_lmt_upd;
9700: Routine (pdc_card_lmt_upd) ambiguous - more than one routine resolves to given signature.I will really appreciate, if someone can help me in dropping both procedures.
Regards,
Navaid Arif