Answer Posted / sudipta santra

This feature is available in Oracle reports.

Anchoring objects hold one object inside the parent itself
while Before-Report trigger gets fired.

As an ex. We can set some library files (pll/pld/dll) or can
attach image / logo etc.

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