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.
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 ...