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
9482 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
Philip Kang
Appian Employee
over 7 years ago
you mean cast smallint to int in MySQL store procedure for Output "total_value"? I am using a Cloud instance with attached MySQL database, has no idea whether it's been patched or not. If you can check, I will send the cloud UI in email.
Thx!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Philip Kang
Appian Employee
over 7 years ago
you mean cast smallint to int in MySQL store procedure for Output "total_value"? I am using a Cloud instance with attached MySQL database, has no idea whether it's been patched or not. If you can check, I will send the cloud UI in email.
Thx!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data