sequence.NEXTVAL in INSERT ALL is evaluated only once. Either you change to multi INSERT, either you wrap the sequence.NEXTVAL in a function.