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

smcgill over 9 years ago

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

Discussion posts and replies are publicly visible

Parents

0 Amitkumar over 9 years ago

You can try declaring returnCode as OUT parameter to stored procedure instead of having it as a resultSet2, set this parameter value inside the stored proc. And also create data input parameter on execute stored procedure node with the name same as stored proc OUT parameter and store the value into multivalued process variable.

Additional logging can be enabled by adding the following to appian_log4j.properties:
· log4j.logger.com.appiancorp.ps.ss=DEBUG
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Amitkumar over 9 years ago

You can try declaring returnCode as OUT parameter to stored procedure instead of having it as a resultSet2, set this parameter value inside the stored proc. And also create data input parameter on execute stored procedure node with the name same as stored proc OUT parameter and store the value into multivalued process variable.

Additional logging can be enabled by adding the following to appian_log4j.properties:
· log4j.logger.com.appiancorp.ps.ss=DEBUG
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data