Skip to main content
1-Visitor
August 29, 2018
Question

executing stored procedure issue

  • August 29, 2018
  • 1 reply
  • 1031 views

Hi,

I wrote a stored procedure and tried to execute in thingworx using execute command and kept the type as sql query but I am getting error and when I execute it am getting result set as Nan. Below is the command I wrote:

 

execute Modelwise_RollOff_QaOk @typeName = [[Type]] ,@shiftName = [[ShiftName]],@model = [[Model]];

288E30E7.PNG

 

Please provide some help.

 

Thanks,

V shalini.

1 reply

5-Regular Member
August 30, 2018

Hi @svisveswaraiya_285988 what exactly does this procedure do? Also could you share what sort of output does this service provide?