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.
Discussion posts and replies are publicly visible
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.