Answer Posted / Meenakshi Yadav

Oracle Forms Services interact at three different levels: Application Level, Presentation Server Level, and Client Level.
1. Application Level: This is where the business logic of the application resides. It includes the forms, reports, triggers, and packages that define the application's functionality.
2. Presentation Server Level: This is where the runtime environment for the application resides. It includes the Forms Services processes that execute the forms and handle user interactions.
3. Client Level: This is where the user interface resides. It includes the browser or desktop client that displays the form to the user and handles user input.

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