If the SP does not have any dependency, you can just 'DROP' it and 'CREATE'
it. That will work.

Artur

----- Original Message -----
From: "Daniel Rail" <daniel@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, September 26, 2002 10:31 PM
Subject: Re: [ib-support] This is a bug???


> At 26/09/2002 06:08 PM, you wrote:
> >Hi.
> >Sometimes when editing a stored procedure while someone else is also
> >connected on gdb and alter the parameters data type this change only has
> >effect after everybody (including me) disconnect from the gdb.
> >An example, changing a parameter datatype from varchar(4) to varchar(10).
> >Anyone have tha same problem??
>
> That is how it is designed. The stored procedures are compiled on the
> first connection to the database. Just to let you know that MS-SQL
> operates the almost the same way, the stored procedure is compiled the
> first time it is called after SQL Server is started, but can be forced to
> recompile, by using a built-in function, the next time the stored
procedure
> is called.
>
>
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.accramed.ca)
>