We are using Execute Stored Procedure to execute DB operations. we are facing issues in retrieving the resultset in case an output parameter is defined in the procedure.
Definition - @ErrorMessage varchar(4000) outputThe Procedure is for get operation and below are the observations :fn!executestoredprocedure : The resultset is not returned
O/p - [success:false,error:Error processing results in procedure XXXXX ]
Smart Service : The smart service node errors out with an alert for null pointer.Alert : There is a problem with task “Execute Stored Procedure” in the process “XXXXXX”. java.lang.NullPointerExceptionProblem: An error occurred in executing an Activity Class. * These issues are resolved and the resultset is properly populated if we remove the Output param mapped in the procedure.* Even a declaration of output param is good enough to break the call i.e no processing just a standard declaration.* If I don't attempt retrieving the resultset, even with parameters declared the smart service executes (doesn't throw null pointer exception).
Discussion posts and replies are publicly visible
© 2023 Appian. All rights reserved.