Answer Detail: RE: What is the diffrence between AFTER PARAMETER TRIGGER and BEFORE REPORT TRIGGER?

GeekInterview.com > Interview Questions > Oracle Apps > D2K

Print |

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

February 02, 2008 02:23:53	#1
Arun.Gopalan	Member Since: February 2008 Total Comments: 2
RE: What is the diffrence between AFTER PARAMETER TRIGGER and BEFORE REPORT TRIGGER?
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.