Subject | Stored Procedure Parameters |
---|---|
Author | Valdir Stiebe Junior |
Post date | 2003-06-18T13:36:53Z |
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.
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.