DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Dear ....

    I am working on Oracle Application 11i (11.5.5- Finance application) we have around 60 application users.

    Before shutting down the database i have to send a mail to them for down time otherwise if they will lose the data.
    is there any way where i can send them a online message when they are using the application they will get a message "Database will not available after .... " etc etc.
    I mean to say shall i send a online message to them while they are using application instead of sending mail to them because sometimes they are really busy using application they might not get time to check the mail & if i shutdown the database they may lose the data .....

    Please help me on above problem or please send me a mail on sthakkar1@rediffmail.com....

    Thanks in advance ....


  2. #2
    Join Date
    Dec 2001
    You may use the CUSTOM library to develop a WHEN-NEW-FORM-INSTANCE trigger procedure.

    1. Define a new profile option contains an indicator / the message you want to pop-up

    2. Develop a WHEN-NEW-FORM-INSTANCE (or other that you feel comfortable) trigger to look for the above profile option.

    3. If the option value is not NULL, pop-up a message.

    4. That's it.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.