Does your current statement really work and just takes a long time? Have you
seen it finish on a smaller test table? I'm thinking it may not work because
there is only one insert statement and as soon as the primary key constraint
is violated, your PL/SQL block control falls into the exception block and
never returns to the insert statement.
You may need to group by the four columns that make up the primary key and
decide what to do (min, max) with the non-key columns.
Received on Tue Dec 29 1998 - 21:01:59 CST
