What is the use of Validation triggers in Reports?
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 difference between flex mode and confined mode?
List the different types of columns in oracle reports.
How can you execute the user defined triggers in forms 3.0 ?
from where do u receive the information to develop report
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
How do you control the constraints in forms ?
what is bit map and character mode
What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
What is the built_in routine used to count the no of rows in a group?
An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?
What is a combo box?
how to pass 2 variables from one form to other form