You have to ensure the Stored Procedure isn't used by anything in your
database (other stored procedures, triggers, etc.). Once your stored
procedure has NO dependencies, you can change the input parameters.
Once changed, you can re-add the dependencies (triggers, etc.)

Todd

Valdir Stiebe Junior wrote:

> Hi,
> i have a stored procedure SP_TEST with 10 parameters.
> This procedure is executed from some triggers... 'execute procedure
> SP_TEST(.....)'
>
> I add some more parameters, but now can't drop or alter the triggers (it
> raise Invalid Request at BLR offset 21 parameter mismatch for procedure
> SP_TEST
>
> The only way to drop my triggers is to back the store procedure to old
> parameters.
>
> Then after dropping the triggers, i recreated the procedure with the new
> parametres. But when i try to recreate the triggers (i've edited it to use
> the new parameters) the same error is raised.
>
> What could be happening?
>
> Valdir.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> Click Here!
> <http://rd.yahoo.com/M=244522.3313099.4604523.1261774/D=egroupweb/S=1705115386:HM/A=1595054/R=0/SIG=124km4b11/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3313099&yhad=1595054>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

--
Todd Brasseur, A.M.A.A.
COMPASS Municipal Services Inc.




[Non-text portions of this message have been removed]