HI all, i have created a storedprocedure
" CREATE PROCEDURE [dbo].[SPEmployeeDetails]
@EmployeeID nvarchar (50)
AS
BEGIN
SET NOCOUNT ON; SELECT EmployeeName from dbo.Employee where EmployeeID = @EmployeeID
END " which takes EmployeeID as input and returns Employeename. Now i have regirstered DynamicSQLSPService and i am accessing SP by creating SmartObject and given this service object method(i.e. ExecuteNonQuery method). When i deploy it and testing through smart object service tester its giving the below error.
I am using advanced mode while creating smartobject and using Execute Method type.