Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

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