Generating XML output using a concurrent program

To generate XML output using a concurrent program, we simply need to write valid XML content to the concurrent program's output file. This can be done in a variety of ways, for example, PL/SQL procedure, SQL Query, and so on. We are going to explore the PL/SQL method.

The first step is to create a database package containing a single procedure that uses multiple calls of FND_FILE.put_line to write text to the Output File. Once that's done, we will define a concurrent program that calls our PL/SQL procedure and in turn delivers the desired output.

Getting ready

Firstly, what is XML? Extensible Markup Language (XML) is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. XML documents normally begin by declaring some information about themselves, as follows:

<?xml version="1.0" encoding="UTF-8" ?>

This is also known as the prologue. It contains the XML declaration...