create or replace TRIGGER "MD_INDEXES_TRG" BEFORE INSERT OR UPDATE ON MD_INDEXES FOR EACH ROW BEGIN if inserting and :new.id is null then :new.id := MD_META.get_next_id; end if; END;