DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Alerts

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Posts
    334

    Alerts

    Hi,
    In Oracle financial, Does Oracle Alerts part of the application OR part of the database?

    Can some one give me an example of the alert. Let's say I want to write a alert on one of my table when a new row inserted.

    Thanks.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I Believe it's part of the applications suite, however you could create the type of alert you require with a trigger.

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jul 2001
    Posts
    334
    Thanks for the info. Where I can get some useful example codes of alerts, any site/link etc.

    Thanks

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    On Forms, alerts are part of the form. You can customize them and make your own.

    declare btn_id as integer

    on some action (like when a button is pressed):
    change_alert_message('alert_type','Your alert message.');
    btn_id := show_alert('alert_type');
    IF-THEN-ELSE code under this to handle the action (button selected) by the user.

    Ref: Form Builder Reference
    Last edited by stecal; 03-14-2003 at 04:00 PM.

  5. #5
    Join Date
    Jun 2001
    Posts
    20
    triggers are always an option, though I would caution that you be aware of what it may or may not do to your app's upgrade path. Use a naming convention that separates your triggers from delivered triggers, and I recommend against altering delivered triggers unless it's absolutely necessary and documented to the teeth.

    edit - that is, if you're hammering on an app that was developed by someone else. If yer developing it nevermind

    /edit
    Last edited by hux; 03-14-2003 at 03:45 PM.

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