Even though we can write SQL queries in database agnostic manner when we expose database tables as services with WSO2 Enterprise Integrator, there might be some challenges when dealing with stored procedures. Recently I found one such a situation. I was working on a project which was using Microsoft SQL Server as the database. For one use case, there was a requirement to execute an update and return the updated records to the frontend. As you know, we can’t do […]