Trigger fires in the following sequence in a report
-
- Before parameter Form 2. After parameter Form 3. Before Report 4. Between Pages 5. After Report
-
- Before parameter Form 2. Before Report 3. After parameter Form 4. Between Pages 5. After Report
-
- Before parameter Form 2. After parameter Form 3. Between Pages 4. Before Report 5. After Report
-
- After parameter Form 2. Before parameter Form 3. Before Report 4. Between Pages 5. After Report
A
Correct answer
Explanation
Oracle Reports execute triggers in a specific sequence: first the parameter form triggers (Before/After Parameter Form), then the report execution triggers (Before Report, Between Pages), and finally the After Report trigger. This sequence ensures user input is processed before report generation begins.