Hello,

I have a stored procedure in a SQL Server, which looks like that:

CREATE PROCEDURE PTP_GetModCount
@Filekey as varchar(20)
AS
declare @OnlCnt as int
declare @OffCnt as int

I have tried now several things to call this stored procedure with ExecSprocScalar or ExecSproc. When I create a Input parameter for @Filekey
and pass it to one of the ExecSproc functions, the error message told me that the parameters @OnlCnt and @OffCnt are missing.
Do I add those parameters as well, then the error occurs that I have passed too many parameters to the stored procedure.

So has anyone an idea how I should call this procedure?

With kindly regards
Thomas Wetterer