Hi Kevin,

Finally managed to find out the cause. The table PK is a natural key. The parameter passed to the SP need to specify the size. Example:

PROCEDURE [dbo].[cABCDelete]
(
@cpk Char(5)
)
AS
SET NOCOUNT OFF;
DELETE FROM [dbo].[cABC]
WHERE
([cpk] = @cpk)


Thanks for the help.

Regards.