Successful report returning TERMINATED_WITH_ERROR
I'm running Oracle 10g with Reports 9i.
I'm trying (and succeeding) to run a report submitted via a dynamic parameter form. The call works, the parameters are past thru, the report successfully runs to completion and is displayed exactly as it should. The code is:
v_reportserverjob := RUN_REPORT_OBJECT(v_report_id);
v_rep_status := REPORT_OBJECT_STATUS(v_ReportServerJob);
However . . . on checking the report_status, it returns TERMINATED_WITH_ERROR, which throws up all sorts of scary warnings to the user about the report failing. I could just ignore this return value, but I'd rather not, in case the report did genuinely fail one day.
Any ideas why this would be returning TERMINATED_WITH_ERROR when it did in fact not TERMINATE_WITH_ERROR?
Thanks
Dave