mule3 inserts data into two tables in a query

Mulesoft allows to execute a single operation at a time. You cannot execute two insert operations together.

Bulk operations accept bulk input parameters, but allows only one operation either insert, update or delete.

However, if you want to combine two insert operations then you can use Stored Procedure. You can pass dynamic input parameter in Stored procedure which will solve your problem

  <db:stored-procedure config-ref="dbConfig">
    <db:sql>{ call updateEmployee('EmailID', :emailID) }</db:sql>
    <db:input-parameters>
        #[{'emailID' : payload}]
    </db:input-parameters>
</db:stored-procedure>

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top