Different triggers...?

Raj2007

DW Apprentice

Reputation: +3/-0
Offline

Offline

Posts: 25

Lightning for DW Forum

Different triggers...?

« on: July 02, 2007, 08:52:58 pm »

Hi all,

I am having some doubts on Triggers...

There are different types of Triggers available in PL/SQL such as Before report, After Report, etc...,

Can anybody give what are the different types of Triggers that are available in Pl/SQL?

These Triggers are again classified for Reports, RowLevel, etc..,


	Logged

Whoever

Administrator

Reputation: +34/-0
Offline

Offline

Posts: 124

Different Report triggers

« Reply #1 on: July 17, 2007, 11:28:46 am »

The different types of triggers used in reports are as follows -

Before Report - This trigger is fired after the Query is executed but before report is executed and the records are displayed.

Before Parameter form - It is fired before the Runtime Parameter Form is displayed. We can use this trigger for validation of command line parameters.

After Parameter form - It is fired after the Runtime Parameter Form is displayed. We can use this trigger for validation of command line parameters.

Between pages - It is fired before each page of the report is formatted, leaving the very first page.

After Report - If the report execution fails, this will be fired.