Answer Posted / guest

There are two phases of block coordination: the
clear phase and the population phase. During, the
clear phase, Oracle Forms navigates internally to the
detail block and flushes the obsolete detail records.
During the population phase, Oracle Forms issues a
SELECT statement to repopulate the detail block with
detail records associated witjh the new master record.
These operations are accomplished through the execution of
triggers.

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