What are the type of triggers available in Oracle Reports ?

Answer Posted / satbir

There are five types of trigger in Oracle Reports

Before Parameter Form
Fires before the Runtime Parameter Form are displayed. Can
access the PL/SQL global variables, report level columns
and manipulate accordingly.

After Parameter Form
Fires after the Runtime Parameter form are displayed. Used
to validate the parameter values.

Before Report
Fires before the report is executed but after the queries
is parsed and date is fetched.

Between Pages
Fires before each page of the report are formatted, except
the very first page. This page is used to customize page
formatting.

After Report
Fires after the report previewer are exited, or after
report output is sent to a specified destination.

Is This Answer Correct ?    113 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an SQL FORMS ?

2383


if u want to delete all these detail block etc what will happen in form

1574


What do you understand by lov and how can it be used?

643


can you convert or reverse engineer a fmx back to a fmb file?

787


did u p prepared complex report

1675






Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1632


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

1905


what are the oracle forms services components include?

640


Explain how one can iterate through items and records in a specified block?

619


How can we expand Parameter Form Canvas on Reports 6i?

2057


what are the new features introduced in oracle form services in 11g release 2?

671


In what sequence do triggers get fired by oracle forms?

619


what is tripstop report?

1421


hiding item in report how like that properly,thats manually but at runtime i want to do

2683


what exactly u write in when_new_form_instance

3047