CREATE OR REPLACE TRIGGER trg_PATCH_DDL_HISTORY
    after create or drop or alter or comment or grant or RENAME or REVOKE on schema
declare
    v_user              varchar2(128) := lower(sys_context('USERENV', 'OS_USER'));
    sql_text            ora_name_list_t;
    n                   number;
    v_stmt              clob;
begin 
    n := ora_sql_txt(sql_text);

    for i in 1..n loop
        v_stmt := v_stmt || sql_text(i);
    end loop;
    insert into PATCH_DDL_HISTORY (insert_dttm, user_name, operation_type,       object_type,       object_name, sql_script)
                           values (    sysdate,    v_user,   ora_sysevent, ora_dict_obj_type, ora_dict_obj_name,     v_stmt);
end;
/