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
+1
person also asked this
people also asked this
Replies
11 replies
Subscribers
8 subscribers
Views
11392 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
Call Stored Procedure
aloks0189
Certified Lead Developer
over 8 years ago
~~~ PLSQL Stored Procedures ~~~
Hi,
I have created a Stored Procedures in DB, Is there any Appian Function Available to call Stored Procedures like
call ProcedureName()
Actually there is a Shared Component named as Execute Stored Procedure, but i would like to know is there any other way(provided by Appian By Default) without using this Shared Component
Thanks
OriginalPostID-239853
Discussion posts and replies are publicly visible
0
Sachin
A Score Level 1
over 8 years ago
@Alok there is a function 'executestoreprocedure' to execute procedure
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
@Sachin executestoreprocedure function will be available only when we install the Shared Component named as Execute Stored Procedure, but i would like to know is there any other way to achieve this rather than depending on Shared Component
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bhanuprakashm
over 8 years ago
Hi Alok Singh,
if you want to execute the stored procedure from appian there are two ways one is using execute store procedure smart node and another one is using fn!executestoreprocedure function
They is no other way to execute store procedure..
.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bhanuprakashm
over 8 years ago
Can you explain you scenario for other way to execute the store procedure..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sachin
A Score Level 1
over 8 years ago
@alok as the @Bhanu explained on the above comment there are only two OOTB features to execute the procedures
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
@bhanu Do I need to install Execute Stored Procedure plugins to use fn!executestoreprocedure
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
@bhanu and @sachin I think there is no OOTB in Appian to call stored procedure, apart from Execute Stored Procedure shared component
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sachin
A Score Level 1
over 8 years ago
@Alok follow this link for the deployment of plug-in
forum.appian.com/.../Appian_Plug-ins.html
hope this is helpfull
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Ben Edwards
A Score Level 3
over 8 years ago
aloks176, to answer your question more concretely, the fn!executestoreprocedure function is not available in Appian out of the box. You can take look at the provided functions at this documentation page:
forum.appian.com/.../Appian_Functions.html
It seems that the following shared component would need to be installed to provide that function:
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
@sachin the question was not About how to install plugins, it was about do we have any OOTB functions to call stored procedurs, and as per my understanding there are no OOTB functions to do this. fn!executestoreprocedure function is not available in Appian out of the box. I am agree with @bene as he explained above
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>