Too Many Arguments In Stored Procedure?

Hello,

When I try to call a stored procedure I get an SQL-exception reading "Procedure or function insert_member has too many arguments specified."

As far as I can see the number of parameters in the application match the number of arguments in the stored procedure. I supply 10 parameters in the application and 10 in the procedure. Is the location of the declaration of the argument cgpID a problem?




ALTER PROCEDURE [dbo].[insert_member]

(

@mbrFirstName nvarchar(15),

@mbrLastName nvarchar(15),

@mbrStreetAddress nvarchar(15),

@mbrPostalAddress nvarchar(15),

@mbrTelephoneHome nvarchar(15),

@mbrTelephoneJob nvarchar(15),

@mbrEmail nvarchar(15),

@mbrActivityGroupID int,

@mbrPaymentMethod int

)

AS

INSERT INTO dbo.member(mbrFirstName, mbrLastName, mbrStreetAddress, mbrPostalAddress, mbrTelephoneHome, mbrTelephoneJob, mbrEmail)


VALUES (@mbrFirstName, @mbrLastName, @mbrStreetAddress, @mbrPostalAddress, @mbrTelephoneHome, @mbrTelephoneJob, @mbrEmail)


declare @cgpID int

set @cgpID = (select cgpID from currentgroup where cgpActivityGroupID = @cgpActivityGroupID)


INSERT INTO member_currentgroup

(mbrID, cgpID, mcgPaymentMethod)


values

(@@identity, @cgpID, @mcgPaymentMethod)