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.
Printable View
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.
I Believe it's part of the applications suite, however you could create the type of alert you require with a trigger.
HTH
Thanks for the info. Where I can get some useful example codes of alerts, any site/link etc.
Thanks
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
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