11g r2
i have a statement
BEGIN
FORALL q IN 1..l_ssd_table.count SAVE EXCEPTIONS
INSERT /*+ APPEND_VALUES */ INTO stu_schedule_detail VALUES l_ssd_table(q);
EXCEPTION
write some stuff , etc
when i run this code i get:
ora-38910 BATCH ERROR MODE is not supported for this operation
Now, i did try using this method of tracking errors at one point in time, and i think i gave the errlog table its own name (not the default ERR$_tablename).
but i thought i got rid of that -- but i can't find any such table when i look for it amongst the table names oin my schema.
how do i disable the dml error logging (without knowing what the table name is)? or what did i goof up?
the reason i want to use the SAVE EXCEPTIONS is to write all rows even if error is encountered on unique constraint.
any help is appreciated.
Mariann