AnsweredAssumed Answered

Stored Procedure Read or Write?

Question asked by redhatva on Oct 24, 2016
Latest reply on Jul 15, 2017 by dcollins724067

Again - I'm a newbie at Boomi - but highly confused by the operation of Database Connector with Stored Procedures.. I have a stored procedure with 1 INPUT parameter of type varchar / char / string.


To me this stored procedure is a write operation as it is doing insert / update delete behaviors.. But when I create the profile for it - it will not expose any parameters. It considers the INPUT parameter to be a field - WEIRD


However if I change the operation to a READ - I can create an input parameter...


So - what is the correct way to do this? Mark it as a read operation - even though I do not plan to read anything with this stored procedure?