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