Answer Posted / Peshkar Tiwari

Bind parameters are statically defined at form design time, while lexical parameters are dynamically defined within a form block using dynamic SQL. Bind parameters are referenced by name, while lexical parameters are referenced by number.

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