What is the diffrence between AFTER PARAMETER TRIGGER and BEFORE REPORT TRIGGER?

Interview Candidate
Nov 26th, 2007
6
8229

Showing Answers 1 - 6 of 6 Answers

Arun.Gopalan
Profile Answers by Arun.Gopalan

Feb 28th, 2008

Query which has to be run by the report is parsed at the end of AFTER PARAMATER TRIGGER. Hence values that need to be provided for the bind and lexical variables should be assigned in or before this trigger. In BEFORE REPORT TRIGGER, the parsing is already done and changes to the values of these parameters cannot be handled.

sateesh.talanki
Profile Answers by sateesh.talanki Questions by sateesh.talanki

Apr 18th, 2008

After parameter Trigger: It will fire after the parameter form is displayed.here we can do validation on parameter values
Before Report Trigger: It will fire before the report is execured and after the query is parsed and date is fetched.