What is the use of Validation triggers in Reports?
- 2 Answers
- 10983 Views
- GE, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is the "LOV of Validation" Property of an item? What is the use of it?
Two popup pages can appear on the screen at a time ?
What is the difference between bind and lexical parameter?
What is the built-in function used for finding the alert?
Is it possible to insert comments into sql statements return in the data model editor?
What do you mean by a pop-up window ?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
What are the various sub events a mouse double click event involves?
can u call procedure or function is sq l query in reports
What is the difference between formula column and place holder?
When will ON-VALIDATE-FIELD trigger executed ?
i am writing a query select EmpNo from Emp how can i call in after parameter form
Oracle General 
