i have a store procedure like this
ALTER proc [citrus_usr].[pr_ins_upd_reqdtls](
@pa_id numeric
, @pa_action varchar(50)
, @pa_req_slip_no varchar(100)
, @pa_req_date datetime
, @pa_boid varchar(16)
, @pa_boname varchar(150)
, @pa_sholder varchar(150)
, @pa_tholder varchar(150)
, @pa_login_name varchar(100)
, @pa_chk_yn smallint
, @pa_rmks varchar(200)
, @pa_error varchar(8000) output
)
as
begin
...............
and from front end i am calling like this
cmd.Parameters("@pa_error").Direction = ParameterDirection.Output
cmd.Parameters.Add("@pa_error", SqlDbType.VarChar, 8000)
it is giving error too many arguments specified
--