The Before Report trigger fires before the data is fetched and the report is executed but after the queries are parsed.
Definition Level |
Report |
On Failure |
Displays an error message and then returns to the place from which you ran the report. |
The Before Report trigger fires before the report is executed but after the queries are parsed.
You can think of order in this way:
Queries are parsed.
Before Report trigger fires.
Report is executed (that is, fetch data+format output)
Consistency is guaranteed if you do DML and DDL in (or before) the After Parameter Form trigger. It nondefault be guaranteed in the Before Report trigger, since Reports Builder may have to start some work on data cursors before that trigger based on the definition of the report. One thing Reports Builder always does before the Before Report trigger is to describe the tables involved and open cursors. Any change to the tables after that will not be seen by the report.
Copyright © 1984, 2005, Oracle. All rights reserved.