Answer / Kuldeep Kumar Singh

In Oracle Forms Reports, the WHEN-NEW-FORM-INSTANCE trigger fires immediately after a new instance of the form is created. It's useful for initializing variables, setting defaults, or performing actions that should only occur once per form session. Here's an example:
1. Declare necessary variables at the form level:
DECLARE
my_variable NUMBER;
2. Add the trigger to the form:
WHEN-NEW-FORM-INSTANCE
BEGIN
-- Perform your initialization logic here, such as setting defaults or loading data into the form.
...
-- Assign initial values to variables.
my_variable := 0;
END;

Can you change the alert messages at run-time?

2 Answers  

---

What is 4-way match?

2 Answers   Zensar,

---

List the Types of Items?

1 Answers  

---

How can you hide the report in Apps?

1 Answers  

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1 Answers  

---

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.

2 Answers  

---

What is the built-in used for showing lov at runtime?

1 Answers  

---

what is difference between group above and group left report

1 Answers   Oracle,

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

1 Answers  

---

What are the built-in used for getting cell values?

1 Answers  

---

What is difference between open_form and call_form?

2 Answers  

---

What is the difference between Anchoring Object and Enclosing Objects ?

1 Answers   GE, Netsoft,

---