Answer Posted / ravi

This trigger executes before the input goes into to any data
or control block. This trigger will execute only once when
data block gets input focus.

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

2226