Subject Stored Procedure Parameters
Author Valdir Stiebe Junior
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.