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 |
How to create lov dynamically in oracle forms which is data comes from database procedure of out parameter, data will will out parameter of procedure base
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.
Is it possible to set a filter condition in a cross product group in matrix reports?
What is a property clause?
What is a combo box?
can my report have different layouts
What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?
How can a cross product be created?
When will ON-VALIDATE-FIELD trigger executed ?
Can we invoke one form from another in a multi-forms application?
Any attempt to navigate programatically to disabled form in a call_form stack is allowed?
what are different types of canvas views?