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
5 subscribers
Views
9487 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
Parents
0
Sally Mason
Appian Employee
over 7 years ago
It could be that "price" stored as a double or number and the return value is not Integer, Try changing "OUT total_value" to be the same type as "price"? or cast to Integer?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sally Mason
Appian Employee
over 7 years ago
It could be that "price" stored as a double or number and the return value is not Integer, Try changing "OUT total_value" to be the same type as "price"? or cast to Integer?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data