Since today is 12th november and since the first document falls under 30 days , altert or popup must appear on the screen stating that its due for renewal.
create table emp_docu ( emp_no varchar2(20),edoc varchar2(3),exp_dt date) insert into emp_docu VALUES ('A','PP','30-NOV-2012') insert into emp_docu VALUES ('B','PP','15-FEB-2013')
Arif75 wrote:To display a popup on the client, you need to decide the basic architecture for this - client initiated popup (data pull), or server initiated popup (data push)?
Hi , i have a small requirement, i am using .dot net frame work to show a pop up on desktop like reminder , can i do that using any oracle tools i am using oracle 10g along with forms 6i , i am using one query for this.
For example there is one table for employee documents which maintains their passport information like when it is expiring.Befor one month of expiration date the pop up alerts the concerned user stating that some passports are due for renewal.How this is dealt with depends entirely on business requirements and ability to audit what happened and what fail to happen.
Arif75 wrote:First explain the architecture you want to use and the business requirements. For example, what happens to notifications that are late and failed delivery? Retry? Escalate? Try smtp notification instead? Delete notification?
Thanks for the response billy, can i get any examples on net to accomplish this task or can you send me some articles which i can read and implement this
Arif75 wrote:Then you need an alternative client to Forms. A custom Java or .Net client application for example.
yes billy this is for forms but i want to run it on desktop , something using timer and we dont need to have form open everytime.