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.
I Believe it's part of the applications suite, however you could create the type of alert you require with a trigger.
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!
Thanks for the info. Where I can get some useful example codes of alerts, any site/link etc.
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 03:00 PM.
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
Last edited by hux; 03-14-2003 at 02:45 PM.
Click Here to Expand Forum to Full Width