Intermediate
Q: | |
16-22. | Executing the procedure results in an error because DBMS_SQL treats :OLD and :NEW as ordinary bind variables; consequently, it complains that not all the binds have been assigned. In short, the :OLD and :NEW predicates can’t be directly referenced in statements executed via dynamic SQL. |
Q: | |
16-23. | The following template shows how to raise an error when a DML statement violates a business rule:
|
Q: | |
16-24. | (b). Object privileges must be granted directly to the trigger owner and cannot be acquired through database roles. |
Q: | |
16-25. | The triggers are:
|