MySQL Forums
Forum List  »  Stored Procedures

Re: How to create Stored Procedure to INSERT multiple Rows in a table
Posted by: Hemant Mehta
Date: April 27, 2020 06:35AM

Good Morning Peter!
Looking at the link above, the approach seems to be loading a XML file(picking from a location on Server) into a TABLE.
My scenario is
I have created an API on ESB. The consumer calls my API with XML message,
That gets parsed in my ESB and then I need to do multiple INSERTS based on the XML message.
Not Sure if we would be allowed to first convert the incoming message and create a file on Server and then load it using the above steps.

Also, with this function will all subsequent LOAD Append the Data/Rows sequentially? And Table keeps getting enriched with every message

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.