CREATE OR REPLACE TRIGGER m4tg_del_val_fases_alta
   BEFORE DELETE
   ON m4t_val_fase_alta
   FOR EACH ROW
BEGIN

CREATE TABLE schema_audit (
   user_responsible VARCHAR(20),
   date_commited DATE,
   table_name VARCHAR2(20),
   operation VARCHAR2(1),
   operation_code VARCHAR2(2000)                                 -- or a long?
);

CREATE OR REPLACE TRIGGER schema_audit_trg
   AFTER INSERT OR DELETE OR UPDATE
   ON schema_name                                         -- Is this possible?
   FOR EACH ROW
DECLARE
   v_operation   schema_audit.operation%TYPE;
BEGIN
   IF INSERTING
   THEN
      v_operation := 'I';
   ELSIF UPDATING
   THEN
      v_operation := 'U';
   ELSE
      v_operation := 'D';
   END IF;

   BEGIN
      INSERT INTO schema_audit
                  (user_responsible, date_commited, table_name, operation,
                   operation_code)
         SELECT USER, SYSDATE, v1.table_name, v_operation, v2.code
           FROM unknown_view1 v1, unknown_view2 v2    -- This is what i need!
          WHERE 1 = 1;
   EXCEPTION
      WHEN OTHERS
      THEN
         raise_application_error
                          (-20001,
                           'Sweet baby Jesus, the audit registration failed!'
                          );
   END;
END;