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.
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
I was also facing same issue of "not able to run package" from Thingworx service with below command,
(ORA-00900: invalid SQL statement)
but, I changed the command as below
it gives me result as - ( null), but it actually works at backend.
This might gives you some clues.
Is there any scope to get the result set from the stored procedure as Union of the two result set ? If so you can bind to infotable ,Else i think you need to separate the two result set to have two different infotable and then union both infotable into one at thingworx side