How can I drop a Stores Procedure

Posted in 2003

Summary

Julian Parro, on IDS 9.30.UC2, could not drop one of two stored procedures with the same name and got error -9700 (routine ambiguous). Rolf Wasteson explained this is routine overloading in 9.30. Paul Watson and Debbie Butler said to include the parameter data types in DROP PROCEDURE, for example name(int,int) or name(char). This resolves the ambiguity.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Versions, Editions & End-of-Life

Parro Garcia, Julian — Fri, 17 Jan 2003 11:54:00 — source: IIUG Forums & Mailing Lists

Hello, all: We work with IBM IDS 9.30.UC2 and have two stores procedure with the same name, I need to drop it, but I can't, the error is: SQL Error (-9700):Routine (m4pr_gr_clc_hpirpf) ambiguous - more than one routine resolves to given signature Thanks, Julián Parro

↪ replying to Parro Garcia, Julian

ROLF.WASTESON@INFODATA.SEMA.SE — Fri, 17 Jan 2003 14:54:29 — source: IIUG Forums & Mailing Lists

--- Inkommet från INFODATA.DAF1489 +46 8 738 47 68 03-01-17 15.51 --- Inkommet från INFODATA.DAF1489 +46 8 738 47 68 03-01-17 15.39 Hi, it has to do with the routine overloading that the object relational facilities of 9.30 supports. You will have to include the parameters of the procedure also in the drop statement to instruct which of the variants you want to drop. Regards, Rolf ************************************************************************* From: JParroG@fcc.es To: ids@iiug.org Date: Fri, 17 Jan 2003 06:54:00 -0500 Subject: How can I drop a Stores Procedure [26] Message-Id: <200301171154.GAA29675@ace.iiug.org> Hello, all: We work with IBM IDS 9.30.UC2 and have two stores procedure with the same name, I need to drop it, but I can't, the error is: SQL Error (-9700):Routine (m4pr_gr_clc_hpirpf) ambiguous - more than one routine resolves to given signature Thanks, Julián Parro ---- 03-01-17 15.39 ---- Sänt till ---------------------------------- -> JParroG(a)fcc.es ---- 03-01-17 15.51 ---- Sänt till ---------------------------------- -> IDS(a)IIUG.ORG

↪ replying to Parro Garcia, Julian

paul@oninit.com — Fri, 17 Jan 2003 15:43:42 — source: IIUG Forums & Mailing Lists

drop procedure sp_name(int,int) drop procedure sp_name(int,int,int) etc "Parro Garci...." wrote: > > Hello, all: > > We work with IBM IDS 9.30.UC2 and have two stores procedure with the same > name, I need to drop it, but I can't, the error is: > > SQL Error (-9700):Routine (m4pr_gr_clc_hpirpf) ambiguous - more than one > routine resolves to given signature > > Thanks, > > Julián Parro -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Parro Garcia, Julian

Butler, Debbie — Fri, 17 Jan 2003 15:45:50 — source: IIUG Forums & Mailing Lists

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2BE3E.EF68FC80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable You need to quantify the procedure with the datatypes so it knows which = one to drop i.e. drop procedure m4pr_gr_clc_hpirpf(integer, integer, char); drop procedure m4pr_gr_clc_hpirpf(char); -----Original Message----- From: Parro Garci.... [mailto:JParroG@fcc.es] Sent: Friday, January 17, 2003 6:54 AM To: ids@iiug.org Subject: How can I drop a Stores Procedure [26]=20 Hello, all: We work with IBM IDS 9.30.UC2 and have two stores procedure with the = same name, I need to drop it, but I can't, the error is: SQL Error (-9700):Routine (m4pr_gr_clc_hpirpf) ambiguous - more than = one routine resolves to given signature Thanks, Juli=E1n Parro ------_=_NextPart_001_01C2BE3E.EF68FC80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2655.35"> <TITLE>RE: How can I drop a Stores Procedure [26] </TITLE> </HEAD> <BODY> You need to quantify the procedure with the datatypes = so it knows which one to drop i.e. drop procedure m4pr_gr_clc_hpirpf(integer, integer, = char); drop procedure m4pr_gr_clc_hpirpf(char); -----Original Message----- From: Parro Garci.... [<A = HREF=3D"mailto:JParroG@fcc.es">mailto:JParroG@fcc.es</A>] Sent: Friday, January 17, 2003 6:54 AM To: ids@iiug.org Subject: How can I drop a Stores Procedure [26] = Hello, all: We work with IBM IDS 9.30.UC2 and have two stores = procedure with the same name,  I need to drop it, but I can't, the = error is:  SQL Error (-9700):Routine (m4pr_gr_clc_hpirpf) = ambiguous - more than one routine resolves to given signature Thanks, Juli=E1n Parro </BODY> </HTML> ------_=_NextPart_001_01C2BE3E.EF68FC80--

Related threads

Glossary

IDS (Informix Dynamic Server)