OriginalPostID-253249
Discussion posts and replies are publicly visible
When I try the Execute Stored Procedure smart service in my process model, I get a "java.lang.NullPointerException" error. No further information to why this error is returned. The stored procedure was tested successfully on SQL Server has one varchar(200) input and Integer output. We are using an Appian 18.4.. I have one input and one output. As SQL Server treats the IN-OUT (as it did when I tested outside of SSMS; SQLCMD command line call), I treated the OUT parameter as IN-OUT with input variable name same as SP parameter with "Save Into" process variable. I even tried setting up output parameter with ACP saving into process variable. Didnt help either. Please help....
PS: as noted by @nellurus, i am not using resultSet1 parameter.