webutil download file from app server
i am calling a report from forms. report uses text_io to write delimited data to app server disk. report info also displays in browser using web.show_document. when i call report from forms i run report, use web.show_document to display in browser and then call webutil to download file to client form appserver. sequence would be in a manner as below:
run_report_object (report_id);
when report = finished then
web.show_document;
end if;
webutil.download_file (filename);
the problem is this: the web.show_document code runs but while this is running the webutil code also is running. but the report has not completed yet so when webutil runs looking for the file the report is supposed to write it cannot find it since the report has not completed. web.show_document fires off a browser session and then immediately runs the webutil code. but i dont want the webutil code to run until the report has successfully completed. does anyone know how to integrate these two functions into one step instead of running the report and allowing it to complete and then executing a separate step to download the file.
thank you