Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Verified Answer
+1
person also asked this
people also asked this
Replies
15 replies
Subscribers
4 subscribers
Views
9328 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
fn!executestoredprocedure error
Philip Kang
Appian Employee
over 7 years ago
simple expression rule using fn!executestoredprocedure gives me "java.lang.Integer cannot be cast to java.lang.Long" error, while smart service works fine in process model.
SP code:
CREATE PROCEDURE SCL_SumContract_Dealer (
IN dealer_id int,
OUT total_value int
)
BEGIN
SELECT SUM(price) INTO total_value FROM contract
WHERE contractstatus_status_id = 1 AND dealer_dealer_id = dealer_id;
END
OriginalPostID-255998
test_sp.txt
Discussion posts and replies are publicly visible