Answer Posted / 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;

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

2227