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
8 subscribers
Views
1478 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi All, We have a requirement to fetch data from external systems by
anagha_abhyankar
over 10 years ago
Hi All,
We have a requirement to fetch data from external systems by making some API calls for one of the customer. They have Oracle packages which we have to call from Appian. One sample is as below:
Role_id :=
asdata.sec_api.get_role_id@asrtw(CpaddRec.carrier_role_name);
ret := asdata.sec_api.grant_ROLE_ACCESS@asrtw(APPID,APPUSER,Role_id,'CP', CpaddRec.client_program_num,'V','L','N');
if ret = 'Y' then
Is there a way with which we can achieve this? This is not a stored procedure or a query which can be executed using the Execute stored proc smart service or Query DB node.
If yes, how can we achieve this?...
OriginalPostID-106226
OriginalPostID-106226
Discussion posts and replies are publicly visible
0
Tim
Certified Lead Developer
over 10 years ago
Looking at the syntax these are Functions within an Oracle package. Functions can be run from a SQL query node against the dual table: select packageName.functionName(inputVar) as qResult from dual
You can then pickup ac!qResult on the output tab
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
anagha_abhyankar
over 10 years ago
Thanks Tim, will check if this works for us and will update here.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
anagha_abhyankar
over 10 years ago
Thanks, this worked out.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel