Hello,
We have an idea at our company, but we are not sure that we can do the job by using Oracle Forms.
Every morning the job is executed. The job populates a table (table TASKS) that represents a pool of tasks for our employees. Every employee should pick tasks for that day by fetching the rows and transferring them to another table (table PICKED_TASKS). Afterwards, every picked task should disappear from the pool for the other employees, making it impossible for other users to pick the same task. Long story short:
- application with 2 data blocks (TASKS and PICKED_TASKS),
- data block TASKS is shared between all employees and everyone should see the same list that contains the unpicked tasks,
- data block PICKED_TASKS is private for each employee and contains picked tasks.
I am aware that we, probably, can do this by using the timers. Is it possible to achieve this kind of behavior in Oracle Forms in more effective and resource lighter way than by using the timers? Any advice is very appreciated. Thank you in advance.
Igor
----------------------------------------------------------------
Oracle Fusion Middleware 11g
Oracle Database 11g Release 2 Enterprise Edition (RAC)