1 Reply Latest reply on Jul 14, 2017 3:19 AM by supandey RSS
    djung Newbie

    Stored Procedure Error

    Hi guys,

     

    I'm trying to run a service that is a SQL query that execute a Stored Procedure from MSSQL.

     

    execute.PNG

    When I try to execute the query on ThingWorx, I get the following error:
    error.PNG

    However, when I execute this exactly stored procedure on SQL Management Studio, it works fine and get the following result:

    result.PNG

     

    Does anyone know how to solve this?

     

    Thanks,

     

    De Hong

      • Re: Stored Procedure Error
        supandey Collaborator

        Hi De Hong, what sort of an sql statement that procedure is executing? I just tested with SQLQuery service with following procedure that requires an input parameter

         

        execute demoproc3 @colname =2

         

        And it works fine. Note procedure contains select statement and returning single column as result