'passthru' in pl/sql concurrent program
is there a standard pl/sql function that we can do a 'passthru', ie: read a text file (output of the other concurrent request), and present it as output of current concurrent request?
scenario:
we have 1 concurrent program (pl/sql) to do processing..
then we initiated another concurrent program(sqlplus, oracle report, or xml publisher) to generate the report
then instead of get user to find the report output file, we will like the program to read the content of the report and present as output of pl/sql concurrent program that do processing.
we are using R12.
p/s: 'passthru' is a function use in PHP, not sure if it is a right name here.