The After Report trigger fires after you exit the Previewer, or after report output is sent to a specified destination, such as a file, a printer, or an e-mail ID. This trigger can be used to clean up any initial processing that was done, such as deleting tables. Note, however, that this trigger always fires, whether or not your report completed successfully.
Definition Level |
Report |
On Failure |
Does not affect formatting because the report is done. You can raise a message, though, to indicate that the report did not run correctly. For example, you could put the system time in a variable in the Before Report trigger and then compare it against the system time in the After Report trigger. If the report took longer than a certain time to run, you could raise an error. |
The After Report trigger does not fire when you are in the Paper Design view.
The After Report trigger will not fire if the report fails as a result
of improper definition of layout objects in the report. However, if the
report definition is proper and the report fails due to an error in the
destination, the After Report trigger will always fire.
Copyright © 1984, 2005, Oracle. All rights reserved.