Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
7 subscribers
Views
1690 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi All, I am trying to call a stored procedure which returns 3 cursor
sunnya527
A Score Level 2
over 8 years ago
Hi All,
I am trying to call a stored procedure which returns 3 cursors but receiving following error.
"java.sql.SQLException: Cursor is closed."
Can anyone help me in this
OriginalPostID-160825
OriginalPostID-160825
Discussion posts and replies are publicly visible
0
Tim
Certified Lead Developer
over 8 years ago
Does the application server log provide any further information? The error is in your stored procedure so you will have to debug it outside of Appian.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sunnya527
A Score Level 2
over 8 years ago
tim I was not able to find any thing in the log i'll check my procedure.Can you clarify my 1 doubt i.e can we return multiple cursors in the execute stored procedure node like the image attached
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 8 years ago
I have used the node previously to capture multiple result sets. Have you checked the instructions that describe how to capture these and provides some basic examples
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel