I have a text file with a special format and I want Oracle reports to read this file as the base query, instead of the SQL statement.
Is it possible to write a C code to parse the file then link this code with the query?
This file is not fixed width, or delimited, it has a special format that need to be parsed.

Thanks.