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
9 subscribers
Views
2739 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Want to execute Stored Procedure using Oracle DB
pradeepd761
over 8 years ago
Hi All, I want to execute a stored Procedure using Oracle DB that has following 3 input parameters.
P_CUSTOMER_ID VARCHAR2(10)
P_PROGRAM_ID NUMBER
P_PART_ATTRIB_ARRAY DV01CICSO.ATTRIBUTES_OBJ_ARRAY_TYPE
As you can see, P_PART_ATTRIB_ARRAY has a structured data type. So, I created a CDT for this input.
In process modeller, I am using "Execute Stored Procedure" smart service and configured all inputs similar to stored procedure inputs.
But while testing I am getting error that - Problem: An error occurred in executing an Activity Class
I also checked Application Server logs, but I have no luck same error was there.
Please help me to find actual error or suggest any work-around.
Thanks in advance.
OriginalPostID-251538
Discussion posts and replies are publicly visible
Parents
0
pradeepd761
over 8 years ago
Hi Alok, I am able to execute sp from backend by using below query and getting desired output msg.
execute PARTICIPANT_MAINTENENCE_PK.Add_participant_account(1,1,NULL);
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
pradeepd761
over 8 years ago
Hi Alok, I am able to execute sp from backend by using below query and getting desired output msg.
execute PARTICIPANT_MAINTENENCE_PK.Add_participant_account(1,1,NULL);
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data