Quote:
Originally Posted by anacedent
>dbms_output.put_line('The room is not available');
no user will ever see it.
|
Not true.
If you turn serveroutput on in SQL*Plus (or other tools that support this) and run a statement the fires the trigger you will see the message.
It's a nice debugging aid (but nothing more).