Answer / swarna.alizerla

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.

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.

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

0 Answers  

---

What is user exit.?

2 Answers   IBM, Synergy, Zensar,

---

running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?

1 Answers   Convergys,

---

What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?

1 Answers  

---

How does the command POST differs from COMMIT ?

2 Answers  

---

What is AppCore and AppCore2 ?

1 Answers  

---

What is the User-Named Editor?

1 Answers  

---

How can a square be drawn in the layout editor of the report writer?

1 Answers  

---

what is integrity n how many integrity rules r there?

2 Answers   Convergys,

---

What are the three types of user exits available ?

1 Answers  

---

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 Answers  

---

What are the default extensions of the files careated by forms modules?

1 Answers  

---