Thanks Craig that reply really helped.
I had used second approach where i converted the INSERT into a loop
with an exception block.but as you said it does take a lot of
time. So i changed the INSERt query itself to exclude the records that
were causing the problem. It sad that the query is
samantha mahindrakar wrote:
Hi
Iam trying to insert records into a table..when an integrity
constarint violation occurs the exception is caughtbut i dont
want the whole thing to be rolled back or stopped because of one
exception.
[snip]
> Is there a way i can just skip the reco
Hi
Iam trying to insert records into a table..when an integrity
constarint violation occurs the exception is caughtbut i dont
want the whole thing to be rolled back or stopped because of one
exception. The insert statement is as follows:
'INSERT INTO '||imputation_table||'
