Answer Posted / Rakesh Kumar Rajak

When deleting a detail block (or any other significant element) in an Oracle Form, the consequences can be quite severe:
1. The layout of the form will change significantly, potentially disrupting its usability and aesthetic appeal.
2. If the deleted block contains critical functionality, such as calculations or validations, those functions will no longer be available.
3. In some cases, deleting a detail block may cause other blocks to become invalid or require extensive modifications to accommodate the change.

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