Limitations In File Write & Append Functionalities In Groovy (Doc ID 2664597.1)

Last updated on DECEMBER 08, 2023

Applies to:

Goal

While using the F1-PDBG batch for file write, facing the following issues:
Select Record algorithm runs an SQL query and returns the output. For every record, the Process Record algorithm invokes a Plug-in script which reads the record and writes it to a CSV file.
But, in this approach, since append functionality is not available, we have to read the existing file content and append the new record. This happens for every record.
So, for example, to write 1000 records, the script will have to read the file 1000 times and each time, append the new record.
Some limitations are: no append method available, have to read the entire file contents and override the file with new content, performance & memory issues for larger records may occur.
Also, this approach has to work in a multi-threaded scenario.

A functionality is required that the records can be appended to an existing file without the overhead of reading the file multiple times and enhancing the performance.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.