We are running in 7.8 using Execute Stored Procedure v1.0.7 on SQL server 2008.

We are running in 7.8 using Execute Stored Procedure v1.0.7 on SQL server 2008.
Data is coming back into a CDT for resultSet1 OK but we also have another CDT set up for resultSet2 for a return code which is not getting anything back at all. The inputs are set up as follows:
resultSet1 (CCX_PostcodeAllocationTotals) - Multi
postcodeArea (Text)
supplierId (Text)
supplierListMemberID (Text)
supplierType (Text)
...
and
resultSet2 (CCX_SProc_ReturnValue) - Multi
returnValue (Number (Integer))

When run in SQL the stored procedure runs returning the two output OK.

Any ideas what is going wrong?
Thanks

OriginalPostID-148833

OriginalPostID-148833

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data