Re: Problem in dropping procedure

You need to do the drop that defines the version you want to drop. ei: DROP PROCEDURE pdc_card_lmt_upd (varchar(19), float, float, float, char(1),char(20), char(15)); or DROP PROCEDURE pdc_card_lmt_upd (varchar(19), float, char(1), char(20), char(15)); When there is only one then a normal drop does drop properly. Eric B. Rowell On 4/12/07, Navaid Arif <navaid.arif@access.net.pk> wrote: > > 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 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >