What is the use of Validation triggers in Reports?

Question Posted / nihar

2 Answers
12062 Views
GE, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the use of Validation triggers in Reports?..

The Validation Triggers are used to validate the data
entered int the parameter form.
If the parameter is having the number format and if the
varchar2 is entered then to restrict such situations the
VAlidation Triggers are used.

Is This Answer Correct ?

12 Yes

0 No

What is the use of Validation triggers in Reports?..

Answer / anuragrajverma

Validation Triggers:-
---------------------------
Validation Triggers are PL/SQL functions that are executed
when parameter values are
specified on the command line and when you accept the
Runtime Parameter Form. (Notice that this
means each Validation Trigger may fire twice when you
execute the report). Validation Triggers are
also used to validate the Initial Value of the parameter in
the Parameter property sheet.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More Oracle Forms Reports Interview Questions

What is a user exit program in oracle reports?

0 Answers

can my report have different layouts

2 Answers

What is a difference between pre-select and pre-query?

1 Answers iFlex,

Can you attach an lov to a field at design time?

1 Answers

List the different types of columns in oracle reports.

0 Answers

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

0 Answers

What are the different window events activated at runtimes?

1 Answers

Give the sequence of execution of the various report triggers?

1 Answers

What is lexical parameter ?

2 Answers Zensar,

What are the two phases of block coordination?

1 Answers

can i write commit in Before report trigger

4 Answers

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through

1 Answers Azri Solutions,

For more Oracle Forms Reports Interview Questions Click Here