oracle10goas

How to run long running report in the background


Oracle Application server 10g

I need to run the long running reports in the background because while the report is running the cursor is loading and the control doesn't return to the user

this feature exist in oracle 6i by set the following parameter

RUN_PRODUCT( REPORTS, 'r_1', ASYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);

How can I accomplish the same in OAS 10g?


Solution

  • Are you using RUN_REPORT_OBJECT? If so, have you set REPORT_COMM_MODE to ASYNCHRONOUS?