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?

Outcomes