Stored Procedure Scalar result

See more:

VB

SQL

stored-procedure

Can you please tell me whats wrong
Fails saying
"Procedure or function 'sp_SetDestinations' expects parameter '@Sex', which was not supplied."

my stored procedure "sp_SetDestinations" works when executed in MSSMS

Using cn As New SqlConnection(ConnStr), cmd As New SqlCommand("sp_SetDestinations", cn)
cn.Open()
cmd.Parameters.Add("@Sex", SqlDbType.Char).Value = DR1("Sex").ToString
cmd.Parameters.Add("@Breed", SqlDbType.Char).Value = DR1("Breed").ToString
cmd.Parameters.Add("@FQA", SqlDbType.Char).Value = gFQA
cmd.Parameters.Add("@Moves", SqlDbType.Int).Value = DR1("Moves")
cmd.Parameters.Add("@Months", SqlDbType.Int).Value = DR1("Months")
gStr1 = cmd.ExecuteScalar().ToString
 
End Using

Thanks