Re: duplicate proc
--0__=8ABBE56ADFFDA4928f9e8a93df938690918c8ABBE56ADFFDA492
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: quoted-printable
if it is version 9.x you can have several Store procedure with same na=
me
but with different parameters.
In order to erase you need it you must include the types of the paramet=
ers
:
create procedere proc1 ()
....
end procedure;
create procedere proc1 ( a char(20), b smallint )
....
end procedure;
drop procedure proc1(char(20), smallint);
drop procedure proc1 ();
Saludos,
Ricardo Rojas Sotelo
=
=20
"Bill =
=20
Hamilton" =
=20
<laidback@fins Para =
=20
co.com> "informix-list" =
=20
Enviado por: <informix-list@iiug.org> =
=20
owner-informix cc =
=20
-list@iiug.org =
=20
Asunto =
=20
duplicate proc =
=20
06-05-05 01:44 =
=20
PM =
=20
=
=20
=
=20
=
=20
=
=20
Informaci=F3n: No Clasificada =
=20
(Embedded image moved to file: =
=20
pic15881.gif) =
=20
=
=20
I have a proc listed in a database twice.
I am unable to drop either of them.
I think the problem started when I made a proc out of a function
and maybe did not drop the function first.
Someone had a similar problem last week, and was told not to delete it =
from
sysprocedures. I did not see what the final resolution was.
Does anyone know how to handle this situation?
procname owner procid mode
numargs isproc specificname
-------------------- -------------------------------- ----------- ----
-----
------ ------ ------------
makeinvwork informix 233 D =
1
t
makeinvwork informix 234 D =
1
t
sending to informix-list
=
--0__=8ABBE56ADFFDA4928f9e8a93df938690918c8ABBE56ADFFDA492
Content-type: image/gif;
name="pic15881.gif"
Content-Disposition: attachment; filename="pic15881.gif"
Content-transfer-encoding: base64
--0__=8ABBE56ADFFDA4928f9e8a93df938690918c8ABBE56ADFFDA492--
sending to informix-list