Dear Community,
I hope all are doing well.
I have create a stored procedure which accepts two parameters. When i am executing the stored procedure from the CRT, it is throwing the below error.
Database error 'Unknown' occurred for 'execute stored procedure '[ext].DELETEITEMSTOCK''. The procedure "DELETEITEMSTOCK" has no parameter named "@TVP_QUERYRESULTSETTINGS".
I am trying to execute the stored procedure like below.
using (var dbContext = new SqlServerDatabaseContext(request))
{
ParameterSet parameters = new ParameterSet();
parameters.Add("@CHANNELID", channelid);
parameters.Add("@TERMINALID", terminalid);
try
{
int rowAffected = dbContext.ExecuteStoredProcedureNonQuery("[ext].DELETEITEMSTOCK", parameters);
}
catch (Exception ex)
{
}
}
Please help me to solve this issue.
