Reporting error from a trigger
My apologies if I have this posted under the wrong community. I wasn't quite sure which one to pick..
I have a trigger on the order lines table conditioned on a status change. When the condition is met, I call a function which does some additional processing. In this processing, I have a need to report a error back to the user if multiple matches are found in a select.
My question is: Is it possible to generate an error from a trigger which could be reported back to the user on the screen? I am a Oracle novice so I'm not sure exactly how triggers function in respect to interacting with a program such as Order Maintenance.
I have a trigger on the order lines table conditioned on a status change. When the condition is met, I call a function which does some additional processing. In this processing, I have a need to report a error back to the user if multiple matches are found in a select.
My question is: Is it possible to generate an error from a trigger which could be reported back to the user on the screen? I am a Oracle novice so I'm not sure exactly how triggers function in respect to interacting with a program such as Order Maintenance.
0