Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.2K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 402 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
How to handle exception of trigger created on base table

Hi Experts,
We have a requirement where we want to create trigger on MTL_SYSTEM_ITEMS_B. The trigger will check whenever reserve flag is updated on item, then trigger has to fire and capture the details in a custom table(The details we are capturing are: Old and New values of reserve flag, WHO Columns and few other).
Now, my doubt is how can we handle exception in a trigger. Is it allowed? Because, we are not sure what and when an error will occur right...?
As I said before, my trigger will have simple INSERT INTO CUSTOM TABLE statement.
If we handle exception(Which I need to know), how the application will show when we are updating reserve flag from application and how it will be displayed when we update the reserve flag by using UPDATE command from DB.
Thanks in Advance,
Srivathsava
Answers
-
You should not be doing this at all! Creating triggers on the supplied tables is not supported and the next time you apply a patch or upgrade, heaven knows what will happen. What you should be doing is connecting to the Alert Manager Responsibility, and creating appropriate Alert Actions. If you need more complex logic, then use a Workflow. This is made clear in the various docs regarding RBS development and numerous MOS articles.
My own experience is that breaking the rules as you are doing may give you a quick fix, but you are stacking up problems for the future. Up to you, I suppose! Though it will be your client who pays the price.
-
Hi John,
Thank you for enlightening me on this :)
I will update the same to them. Lets see what they respond
Thanks,
Srivathsava