Stored Procedure Array Input

Question

Can we pass a list of numbers to input parameter of SP? Is it possible. 
 a!storedProcedureInput( name: "group_ids", value:local!groupids (It is a list of number) ), 
 It's not working as input parameter is defined as INT on DB side but we are passing list of integers.

Aryan · Answer

Yes, I also think we cannot pass list of integers. But even if you want to pass list, pass them in a string separated by any delimiter and then split them inside the SP. Refer to the below thread: https://community.appian.com/discussions/f/plug-ins/11690/execute-stored-procedure-is-not-taking-multiple-values-as-input

Mike Schmitt · Answer

Pass in a list as a comma-separated string, then in the procedure itself you can use functions like FIND_IN_SET (depending on exactly what you need to do with it of course), to act directly on the list.

Stored Procedure Array Input

Top Replies