Hi, Is there a way to call an oracle stored procedure which takes an array of ob

vishale over 11 years ago

Hi, Is there a way to call an oracle stored procedure which takes an array of objects as an input parameter from appian?
I am sure this question has been asked before. I am new to this forum and still trying to find my way around.

Thanks...

Discussion posts and replies are publicly visible

0 sikhivahans over 11 years ago

Hi Vishal, Are you looking for a way to call a stored procedure by passing some inputs to it from appian? If so, Execute Stored Procedure Smart Service is the way of doing it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vishale over 11 years ago

I am able to handle scalar inputs without any problem. I want to pass arrays as inputs. How do I do that? Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 11 years ago

@vishale, Even I faced this problem. My way of doing this is taking multi-valued variable as string (by setting an delimiter) and parsing it back to an array in the routine. Might be, a better solution exists!, Check for more posts here.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim
Certified Lead Developer
over 11 years ago

You could also insert the array into a temporary table and then read them back out with the stored proc.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel