Skip to main content
S
sdaram1-Visitor
1-Visitor
April 26, 2017
Question

How to Execute Stored Procedure Which Has Two Result Set in Thinworx

  • April 26, 2017
  • 4 replies
  • 3314 views

Hi All,

I have Stored Procedure that will return Two Result Sets . I am Trying to Execute This Stored Procedure from Thingworx Service But unable to get results.

While I am running stored Procedure in MSSQL Database i am able to get values in 2 result set but when i run Same Procedure in Thingworx Service nothing is coming.

Please let me know How to resolve this Issues. Looking for positive response.

Regards

Spandhana

    4 replies

    S
    sdaram1-VisitorAuthor
    1-Visitor
    April 26, 2017

    In SQL Server When I execute stored procedure it is getting result in 2 result set

    In My scenario the above values i have to display in Datagrid in Thingworx Composer.

    Steps I have done.

    1)I have Created a Datashape Which have all columns which we are getting from Stored proecure.

    like PLID,PPId,UserId,PathId(resultset1 columns) ..................................................TargetProperty,PropertyValueType,PropertyValue....................................etc(ResultSet2 columns) in single datashape.

    2) I have Created a Service to call my stored procedure.  by mapping my Datashape  "KPI_Main_Grid_DataShape" to service.

    The Stored proecure Expecting some input parameters i am passing default values to execute stored proecure.

    Note:- Here my issue is i am unable to get values from stored procedure when i call from thingworx service.

    I Hope everyone understand my scenario looking for help to resolve my issues.

    Thanks & regards

    Spandhana Daram

    S
    sdaram1-VisitorAuthor
    1-Visitor
    April 27, 2017

    Hi All,

    please look into my issues . Please do needful .Thank you

    Thanks&Regards

    Spandhana

    M
    mlohokare5-Regular Member
    5-Regular Member
    April 27, 2017

    Hi,

    I was also facing same issue of "not able to run package" from Thingworx service with below command,

    EXEC del_pkg.del_tbls

    (ORA-00900: invalid SQL statement)

    but, I changed the command as below

    CALL del_pkg.del_tbls()

    it gives me result as - ( null), but it actually works at backend.

    This might gives you some clues.

    Regards,

    Mahesh Lohokare

    Terms & ConditionsAccessibility statement