procedure my_proc is begin execute immediate 'SET CONSTRAINT MY_UNIQUE_CONSTRAINT DEFERRED'; .. <dml code goes here> end;