Answer Posted / Omprakash

Yes, it is possible to invoke one Oracle Form from another within a multi-form application. This can be done using the 'Invoke' command or by creating links between forms. The invoked form will run in a new window and can share data with the calling form through parameters.

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

2219