Here is my code,

.Parameters.Append .CreateParameter("@EX_GAIN_FROM_PROJECT", adLongVarChar,
adParamInput, , Request.Form("EX_GAIN_FROM_PROJECT")),
this seems incorrect. got error "Formal parameter '@EX_GAIN_FROM_PROJECT'
was defined as OUTPUT but the actual parameter not declared OUTPUT."

This error is pretty weird.

Thx
Pat
==========================================================
create proc dbo.userExperienceOnGrant
@EX_ID int,
@EX_TRAINEE_ID int,
@EX_GRANT_ID int,
@EX_YEAR_REPORTED datetime, -- Per Trainee/Award/Year
@EX_STATUS nvarchar(10),
@EX_GAIN_FROM_PROJECT text,