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.
Do one thing:
Write a package which mainly reading the flat file according to special format by using either TEXT_IO or UTL_FILE or other tools, and return the whole record set(return cursor).
At last, when you create report, use REF sursor to generate report based on this returned cursor.
Hope this will give you a hint.
Thanks for the suggestion, which is very usefull, It seems I will use it unless, someone,can tell me how to link Oracle reports, with C code, to extract the data, (just for performance issues)
Click Here to Expand Forum to Full Width