:::: MENU ::::

In EXECUTE, procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.

  • Jun 25 / 2009
  • 0
Data Types, dbDigger

In EXECUTE, procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.

Following error Message
Msg 8199, Level 16, State 1, Line 3
In EXECUTE , procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.

can occur on all versions of SQL Server. This error message appears when you try to EXECUTE a variable that is not of one of the types listed in the error message. To resolve the error, the variable to be executed must be of a type listed in the error message.

Following is an example to generate the error

DECLARE @i INT
SET @i = 1
EXECUTE @i

Remarks:
In the above error message we try to execute a variable of the type INT. This raises the error.

Consult us to explore the Databases. Contact us