Hi guys need your assistance for this issue ...

First herewith the error i am getting

Error Number: Error 3001
Error Source: ADODB.Command
Error Description: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

and it is due to the call :

cmd.CommandText = "csp_ManUpdContMLSeal"
cmd.CommandType = adCmdStoredProc
cmd.Execute , Parameters:=Array(Me.Vessel, Me.Voyage)

of the stored procedure which is below

---
ALTER PROCEDURE csp_ManUpdContMLSeal
(
@Vsl nvarchar(3) ,
@Voy nvarchar(4)
)
AS
SET NOCOUNT ON

UPDATE dbo.BLCont SET dbo.BLCont.MLSeal = 'NONE'
WHERE ((dbo.BLCont.MLSeal Is Null) OR (dbo.BLCont.MLSeal ='' )) AND (dbo.BLCont.VslArr = @Vsl) AND (dbo.BLCont.VslArrVoy = @Voy)

IF @@ERROR <> 0
RETURN @@ERROR
Else
RETURN 0