Paster-Bachar Gadi · Feb 28, 2019

Ensemble and SQL table value pramaters


Can I use a the SQL  'Table-Valued Parameter' when i call a store procedure in sql outbound adapter using ExecuteProcedure?

to pass multiple rows all together as a block, I need to process all the records in one transaction using commit and rollback (if failure)



0 156
Discussion (1)2
Log in or sign up to continue

To my knowledge you cannot do this on the client side, however it is easy enough to write a stored procedure to take in whatever input you want (say, a JSON object, or a list-of-lists, or some other data type) and use that to parse-and-INSERT on the server side.