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.

Discussion posts and replies are publicly visible

0 aloks0189
Certified Lead Developer
over 8 years ago

@pradeepd761 did you try executing the Procedure through Oracle Prompt, is it getting execute Well?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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
0 aloks0189
Certified Lead Developer
over 8 years ago

@pradeepd761 can you Monitor the process Model and verify what value is getting pass for the Execute Stored Procedure Smart Service, and try executing the Procedure having the same value through Backend, i hope you may get some breakthrough
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel