The formal parameter "@X" was not declared as ? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

The formal parameter "@X" was not declared as ?

Author

Topic

gangelo
Starting Member

6 Posts

Posted - 2009-07-28 : 09:12:45

Any one ever get this? I have never seen this message before:

Message: The formal parameter "@RoundPercents" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.


-- Calling stored proc like this...
declare 
		@SurveyID uniqueidentifier	
		,@UserName varchar(256)
		,@RoundPercents bit

	set @SurveyID = '95825f5c-9f54-4379-b732-acd87bf1fbd4'
	set @UserName = 'userName'
	set @RoundPercents = 0;

	exec dbo.Peo_SelectSurveyUserSurveyProgressStatisticsGeneral 
		@SurveyID
		,@UserName
		,@RoundPercents
		,@TotalItems output
		,@TotalItemsAnswered output
		,@TotalItemsNotAnswered output
		,@TotalRequiredItems output
		,@TotalRequiredItemsAnswered output
		,@TotalRequiredItemsNotAnswered output		
		,@PercentItemsAnswered output
		,@PercentItemsNotAnswered output
		,@PercentRequiredItemsAnswered output
		,@PercentRequiredItemsNotAnswered output


-- The stored proc...
create procedure dbo.Peo_SelectSurveyUserSurveyProgressStatisticsGeneral (
	@SurveyID uniqueidentifier
	,@UserName varchar(256)
	,@RoundPercents bit
	-- General Item Statistics...
	,@TotalItems int output
	,@TotalItemsAnswered int output
	,@TotalItemsNotAnswered int output
	-- Required Item Statistics...
	,@TotalRequiredItems int output
	,@TotalRequiredItemsAnswered int output
	,@TotalRequiredItemsNotAnswered int output
	-- Percent answered/not answered statistics...
	,@PercentItemsAnswered decimal(10,2) output
	,@PercentItemsNotAnswered decimal(10,2) output
	,@PercentRequiredItemsAnswered decimal(10,2) output
	,@PercentRequiredItemsNotAnswered decimal(10,2) output
)

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-28 : 09:16:07

Hi

you are trying to return an output value but have not declared the variable as output.

-------------------------
R..

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-28 : 09:21:17

Hi

 

DECLARE
		@TotalItems		INT  ,
		@TotalItemsAnswered	INT  ,
		@TotalItemsNotAnswered	INT 
		-- Required Item Statistics...
		,
		@TotalRequiredItems            INT  ,
		@TotalRequiredItemsAnswered    INT  ,
		@TotalRequiredItemsNotAnswered INT 
		-- Percent answered/not answered statistics...
		,
		@PercentItemsAnswered            DECIMAL(10,2)  ,
		@PercentItemsNotAnswered         DECIMAL(10,2)  ,
		@PercentRequiredItemsAnswered    DECIMAL(10,2)  ,
		@PercentRequiredItemsNotAnswered DECIMAL(10,2)  

        EXEC dbo.Peo_SelectSurveyUserSurveyProgressStatisticsGeneral 
	'95825f5c-9f54-4379-b732-acd87bf1fbd4',
        'userName',
        0 ,
        @TotalItems			output ,
        @TotalItemsAnswered		output ,
        @TotalItemsNotAnswered		output ,
        @TotalRequiredItems		output ,
        @TotalRequiredItemsAnswered	output ,
        @TotalRequiredItemsNotAnswered	output ,
        @PercentItemsAnswered		output ,
        @PercentItemsNotAnswered	output ,
        @PercentRequiredItemsAnswered	output ,
        @PercentRequiredItemsNotAnswered	output
        -- The stored proc...

)

-------------------------
R..

gangelo
Starting Member

6 Posts

Posted - 2009-07-28 : 09:30:34

quote:
Originally posted by rajdaksha

Hi

you are trying to return an output value but have not declared the variable as output.

-------------------------
R..

How would I possibly do that? In the stored proc right now, I don't do anything with it - it is just defined in the parameter list (no output keyword associated with it). How do you "try to return an output value" that has not been declared as output? The thing I am confused about, is that right now, I don't even do anything with that parameter in the stored proc - it is only defined and nothing more.

gangelo
Starting Member

6 Posts

Posted - 2009-07-28 : 09:31:11

quote:

Originally posted by rajdaksha

Hi

 

DECLARE
		@TotalItems		INT  ,
		@TotalItemsAnswered	INT  ,
		@TotalItemsNotAnswered	INT 
		-- Required Item Statistics...
		,
		@TotalRequiredItems            INT  ,
		@TotalRequiredItemsAnswered    INT  ,
		@TotalRequiredItemsNotAnswered INT 
		-- Percent answered/not answered statistics...
		,
		@PercentItemsAnswered            DECIMAL(10,2)  ,
		@PercentItemsNotAnswered         DECIMAL(10,2)  ,
		@PercentRequiredItemsAnswered    DECIMAL(10,2)  ,
		@PercentRequiredItemsNotAnswered DECIMAL(10,2)  

        EXEC dbo.Peo_SelectSurveyUserSurveyProgressStatisticsGeneral 
	'95825f5c-9f54-4379-b732-acd87bf1fbd4',
        'userName',
        0 ,
        @TotalItems			output ,
        @TotalItemsAnswered		output ,
        @TotalItemsNotAnswered		output ,
        @TotalRequiredItems		output ,
        @TotalRequiredItemsAnswered	output ,
        @TotalRequiredItemsNotAnswered	output ,
        @PercentItemsAnswered		output ,
        @PercentItemsNotAnswered	output ,
        @PercentRequiredItemsAnswered	output ,
        @PercentRequiredItemsNotAnswered	output
        -- The stored proc...

)

-------------------------
R..

Is there something in here I am supposed to see? If so, I don't see it.

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-28 : 09:34:25

quote:

Originally posted by gangelo

Any one ever get this? I have never seen this message before:

Message: The formal parameter "@RoundPercents" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.


-- Calling stored proc like this...
declare 
		@SurveyID uniqueidentifier	
		,@UserName varchar(256)
		,@RoundPercents bit

	set @SurveyID = '95825f5c-9f54-4379-b732-acd87bf1fbd4'
	set @UserName = 'userName'
	set @RoundPercents = 0;

	exec dbo.Peo_SelectSurveyUserSurveyProgressStatisticsGeneral 
		@SurveyID
		,@UserName
		,@RoundPercents
		,@TotalItems output
		,@TotalItemsAnswered output
		,@TotalItemsNotAnswered output
		,@TotalRequiredItems output
		,@TotalRequiredItemsAnswered output
		,@TotalRequiredItemsNotAnswered output		
		,@PercentItemsAnswered output
		,@PercentItemsNotAnswered output
		,@PercentRequiredItemsAnswered output
		,@PercentRequiredItemsNotAnswered output


-- The stored proc...
create procedure dbo.Peo_SelectSurveyUserSurveyProgressStatisticsGeneral (
	@SurveyID uniqueidentifier
	,@UserName varchar(256)
	,@RoundPercents bit
	-- General Item Statistics...
	,@TotalItems int output
	,@TotalItemsAnswered int output
	,@TotalItemsNotAnswered int output
	-- Required Item Statistics...
	,@TotalRequiredItems int output
	,@TotalRequiredItemsAnswered int output
	,@TotalRequiredItemsNotAnswered int output
	-- Percent answered/not answered statistics...
	,@PercentItemsAnswered decimal(10,2) output
	,@PercentItemsNotAnswered decimal(10,2) output
	,@PercentRequiredItemsAnswered decimal(10,2) output
	,@PercentRequiredItemsNotAnswered decimal(10,2) output
)

 
DECLARE
		@TotalItems		INT  ,
		@TotalItemsAnswered	INT  ,
		@TotalItemsNotAnswered	INT 
		-- Required Item Statistics...
		,
		@TotalRequiredItems            INT  ,
		@TotalRequiredItemsAnswered    INT  ,
		@TotalRequiredItemsNotAnswered INT 
		-- Percent answered/not answered statistics...
		,
		@PercentItemsAnswered            DECIMAL(10,2)  ,
		@PercentItemsNotAnswered         DECIMAL(10,2)  ,
		@PercentRequiredItemsAnswered    DECIMAL(10,2)  ,
		@PercentRequiredItemsNotAnswered DECIMAL(10,2)  

        EXEC dbo.Peo_SelectSurveyUserSurveyProgressStatisticsGeneral 
	'95825f5c-9f54-4379-b732-acd87bf1fbd4',
        'userName',
        0 ,
        @TotalItems			output ,
        @TotalItemsAnswered		output ,
        @TotalItemsNotAnswered		output ,
        @TotalRequiredItems		output ,
        @TotalRequiredItemsAnswered	output ,
        @TotalRequiredItemsNotAnswered	output ,
        @PercentItemsAnswered		output ,
        @PercentItemsNotAnswered	output ,
        @PercentRequiredItemsAnswered	output ,
        @PercentRequiredItemsNotAnswered	output
        -- The stored proc...

-------------------------
R..

gangelo
Starting Member

6 Posts

Posted - 2009-07-28 : 09:38:31

Problem solved, I was executing a stored proc later in the first section of posted code that referenced the stored proc in question - it did not have the new parameter defined.

Thank you for your help.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-28 : 09:44:37

to avoid such problem of mixmatch parameter to variable, you should specify the parameter explicitliy when calling the stored procedure


exec dbo.Peo_SelectSurveyUserSurveyProgressStatisticsGeneral 
     @SurveyID      = @SurveyID
    ,@UserName      = @UserName
    ,@RoundPercents = @RoundPercents
    ,@TotalItems    = @TotalItems output
. .  .

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources