error:The parameterized query '(@param1 int,@Paramout int OUTPUT)' expects the parameter '@Paramout', which was not supplied.

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Kurt W. Zimmerman SSCrazy Eights Points: 8676 More actions · Answer 1

What is the error message you are receiving?

Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman

Guras SSCertifiable Points: 6518 More actions · Answer 2

error:The parameterized query '(@param1 int,@Paramout int OUTPUT)' expects the parameter '@Paramout', which was not supplied.

doug.brown SSCertifiable Points: 5608 More actions · Answer 3

Is it possibly a collation issue? I notice in your code the parameter is uncapitalized (@paramout), but in the error message it is capitalized:

error:The parameterized query '(@param1 int,@Paramout int OUTPUT)' expects the parameter '@Paramout', which was not supplied.

What happens if you capitalize it in your code, as below:

Declare @retProcVal int

SELECT @SqlString2 = N'use @dbName exec PROC_01 @param1,@Paramout OUTPUT'

set @ParamDef = N'@param1 int,@Paramout int OUTPUT'

SET @SqlString2 = Replace(@sqlString2,'@dbName',@dbName)

EXECUTE sp_executesql @SqlString2 ,@ParamDef, @param1 = @intHosp,@Paramout = @retProcVal OUTPUT

Guras SSCertifiable Points: 6518 More actions · Answer 4

I figured out what the issue was. There were two stored procedure calls ( I did not have that code in the post) .

Both calls were using the same paramdef. Separated the paramdef and it worked. Thanks

Cookies on SQLServerCentral