When doing a query to insert or update an Oracle table I get errors like “duplicated” when inserting, or “not found” when updating, but it looks like the number of errors has a limit. When that limit is reached, the query stops and the rest of the sentences are not executed.
We migrated from DB2 in mainframe and there is a parameter added as the first sentence in the query to allows any number of errors (SER MAXERRORS -1). Is there something similar in Oracle? Is this something that can be defined using the ALTER command?
luis is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
If you look at e.g. INSERT documentation, https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/INSERT.html, (same for UPDATE) there is an “error_logging_clause” part of the syntax.