Execution of the Procedure: The parameterized query '(@NomeMaquina nvarchar (4000), @IdProcesso int, @ IdCaso int) ProObte' waits for the '@NomeMaquina' parameter, which was not supplied

Help
1

I am trying to execute this query and the message is appearing that @NomeMaquina is not declared, could someone help me? I do not know what is missing

Query

ALTER PROC [dbo].[ProObterProxCasoProcessamento]
@IdProcesso INT,
@nomeMaquina varchar(50)
AS
BEGIN
DECLARE @IdCaso INT

--REALIZA A CONSULTA PELO PRÓXIMO CASO DISPONÍVEL
SELECT TOP 1
	@IdCaso = spc.IdCaso
	
FROM
	statusprocessoscaso spc
WHERE
	(
		spc.IdStatus = 1
		OR
		(
			spc.IdStatus = 2
			AND
			spc.DataAlteracao < DATEADD(MINUTE, -20, GETDATE())
		)
		OR
		(
			spc.IdStatus = 6
			AND
			spc.DataAlteracao < DATEADD(MINUTE, -20, GETDATE())
		)
	)
	AND 
	spc.IdProcesso=@IdProcesso

--ATUALIZA O CONTROLE DO PROCESSAMENTO
UPDATE statusprocessoscaso 
SET IdStatus = 2, DataAlteracao = GETDATE(), Mensagem = 'Caso está sendo executado',NomeMaquina = @nomeMaquina
WHERE IdCaso= @IdCaso

SELECT @IdCaso

END

parameters
parameters872×287 11.1 KB

2

Hi beatriz,

Seems you’re passing null value on @NomeMaquina parameter. You may add additional handling for your NomeMaquina variable before passing it to the stored procedure.

3

Facing the same issue, even though I am passing the value to the parametre during “Execute Query” , still getting an error “Stored Procedure expects value which was not supplied”.

Has anyone resolved this issue?