Procedure or function “” expects parameter '', which was not supplied

Hi Friends:

I am new to SQL and trying write stored proc. I am having some difficulties to get default values as an output result.

I have 2 table:

1)Student_Input:

InputID	SectionID  ParameterName    Sequence

1	100	   FirstName	        1 
        
2	100	   MiddleName	        2  
       
3	100	   LastName	        3  

2)Student_Input_details:

ParameterName	ParameterValue      DefaultValue

FirstName	John	   	        1    
     
FirstName	Troy	                0

FirstName	Mark	   	        0  

I am trying to call ParameterName from Student_Input and Its default value from Student_Input_Details as an output in one table. I am trying with following query but I am getting following error:

Msg 201, Level 16, State 4, Procedure Getparameterdefaultvalues, Line 0
Procedure or function 'Getparameterdefaultvalues' expects parameter '@ParameterValue', which was not supplied.

I am sure I am missing something important here.

Create Procedure Getparameterdefaultvalues
(
@ParameterName varchar(50) ,
@ParameterValue varchar(50) out
)
As
Begin
Select @ParameterValue = DefaultValue from Student_Input_details where ParameterName=@ParameterName
End
Execute Getparameterdefaultvalues 1

I need result like (i.e. ParameterName should only display its default value at runtime):

ParameterName	ParameterValue      

FirstName	John

Apologies If my question is not so cleared. Any help would be grate!! Thx :)

Tags: SQL, SQL Server, SQL Server 2008, Database Development (SQL Server), Stored procedure