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
1360 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
I am looking for an example of a Query Database Integration Service that shows d
markw91
over 9 years ago
I am looking for an example of a Query Database Integration Service that shows dynamic SQL. Any sugges
OriginalPostID-156490
OriginalPostID-156490
Discussion posts and replies are publicly visible
Parents
0
Chris
over 9 years ago
You can use the Execute Stored Procedure node - Data Source Name is in text format, as ="java:comp/env/jdbc/datasource_name_here", Procedure Name is the plain text name of the procedure, ="ProcedureName". From there, create Inputs for each of your parameters including the output paramater - and map them however you would like. Note, node input names must match the parameter names exactly. Let me know if tha thelps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Chris
over 9 years ago
You can use the Execute Stored Procedure node - Data Source Name is in text format, as ="java:comp/env/jdbc/datasource_name_here", Procedure Name is the plain text name of the procedure, ="ProcedureName". From there, create Inputs for each of your parameters including the output paramater - and map them however you would like. Note, node input names must match the parameter names exactly. Let me know if tha thelps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data