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

Get Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.