-
-- TRIGGER_DATABASE_TRUNC_DROP  (Trigger) 
--
CREATE OR REPLACE TRIGGER TRIGGER_DATABASE_TRUNC_DROP
BEFORE DROP OR TRUNCATE
ON DATABASE
DECLARE 
  SENDER VARCHAR2(200);
  RECIPIENTS VARCHAR2(200);
  CC VARCHAR2(200);
  BCC VARCHAR2(200);
  SUBJECT VARCHAR2(200);
  MESSAGE VARCHAR2(200);
  MIME_TYPE VARCHAR2(200);
  PRIORITY BINARY_INTEGER; 
  
BEGIN
  
 
  SENDER := 'xxx';
  RECIPIENTS := 'xxx';
  CC := NULL;
  BCC := NULL;
  SUBJECT := 'xxx';
  MESSAGE := 'Errors drop/trunc';
  MIME_TYPE := NULL;
  PRIORITY := NULL;

  SYS.UTL_MAIL.SEND ( SENDER, RECIPIENTS, CC, BCC, SUBJECT, MESSAGE, MIME_TYPE, PRIORITY );
   RAISE_APPLICATION_ERROR(-20000, 'DROPPING OR TRUNCATING IS NOT ALLOWED IN PRODUCTION DATABASE');
  COMMIT;                         
END;
/