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
What is an SQL FORMS ?
if u want to delete all these detail block etc what will happen in form
What do you understand by lov and how can it be used?
can you convert or reverse engineer a fmx back to a fmb file?
did u p prepared complex report
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
what are the oracle forms services components include?
Explain how one can iterate through items and records in a specified block?
How can we expand Parameter Form Canvas on Reports 6i?
what are the new features introduced in oracle form services in 11g release 2?
In what sequence do triggers get fired by oracle forms?
what is tripstop report?
hiding item in report how like that properly,thats manually but at runtime i want to do
what exactly u write in when_new_form_instance