Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-38910 BATCH ERROR MODE is not supported

880995Aug 29 2011 — edited Aug 29 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2011
Added on Aug 29 2011
5 comments
2,583 views