Data Warehousing Community Forum
October 24, 2019, 01:15:00 am

Pages: [1]   Go Down
  Print  
Author Topic: Different triggers...?  (Read 5329 times)
Raj2007
DW Apprentice
**

Reputation: +3/-0
Offline Offline

Posts: 25


Lightning for DW Forum


View Profile
« 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
advertisement
Whoever
Administrator
*****

Reputation: +55/-0
Offline Offline

Posts: 145



View Profile WWW
« 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.
Logged

Wenn ist das Nunstück git und Slotermeyer? Ja! … Beiherhund das Oder die Flipperwaldt gersput.
Sipra
Founder
*****

Reputation: +56/-0
Offline Offline

Posts: 354


Am the King...


View Profile WWW
« Reply #2 on: July 17, 2007, 02:39:35 pm »

Very useful information from you Whoever.

Can you please specify the sequence of execution of these report triggers in real-time?
Logged

Whoever
Administrator
*****

Reputation: +55/-0
Offline Offline

Posts: 145



View Profile WWW
« Reply #3 on: July 19, 2007, 12:02:22 pm »

The sequence of execution of various Report Triggers -

  • Before Parameter form
  • After Parameter form
  • Before report
  • Between pages and
  • After report
Logged

Wenn ist das Nunstück git und Slotermeyer? Ja! … Beiherhund das Oder die Flipperwaldt gersput.
Pages: [1]   Go Up
  Print  
Jump to: