Oracle Apex : RESTful Web Service with GET handler which will return response in XML format
One of the great feature of Oracle APEX is a RESTful Web Service. You can create a RESTful Web Service and publish it very easily within few minutes. You can create four type of the method for the Resource Handler GET PUT POST DELETE GET method will execute a SQL Query or an anonymous PL/SQL block define in the source section and transforms the result set into the selected format. There are only two format available in the Oracle APEX. JSON CSV Recently, I have been working of a project that requires to transforms the result set into the XML format. This functionality is not available out of the box in the Oracle APEX. But there is a way around for this. You can select the PL/SQL for the Source Type and define an anonymous PL/SQL block or packaged procedure/ function that will transforms the result set into XML format. Let's do it together. This is the XML format which we want as a response from the GET method. <employeesinfo> <department&g