Re: Problem in dropping procedure
Thanks All.
Regards,
Navaid Arif
----- Original Message -----
From: "Eric Rowell" <erowell@gmail.com>
To: <ids@iiug.org>; <classics@iiug.org>; <peoplemix@iiug.org>;
<informix-list@iiug.org>; <admin-tools@iiug.org>
Sent: Thursday, April 12, 2007 5:47 PM
Subject: 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 routineresolves
> > 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
> >
> >
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>