Trigger Learning (DDL triggers)

/* Create a trigger to disallow new objects */

sql> Create TRIGGER no_create 2 after CREATE on SCHEMA 3 BEGIN 4 raise_application_error (5-2000, 6 ' E  Rror:objects cannot is created in the production database. '  7);  8 END; 9/

Trigger created

Sql> CREATE TABLE Demo (col1 number);  CREATE TABLE Demo (col1 number) ORA-00604: recursive SQL Level 1 Error ORA-21000:-2000 raise_application_error Error number parameter out of range ORA-06512: Line 2

/* Create a trigger that suppresses the deletion of objects */

CREATE OR REPLACE TRIGGER undroppablebefore drop on Schemabegin raise_application_error ( -20000, ' You cannot drop me! I am invincible! '); END;

Trigger Learning (DDL triggers)