TOAD cannot format code with the statement "LOG ERRORS REJECT LIMIT UNLIMITED" attached to it. (4284394)

User cannot format a SQL code with the "LOG ERRORS REJECT LIMIT UNLIMITED" clause attached to the code. Without it, the same SQL code formats just fine.

LOG ERRORS clause is not supported in TOAD's formatting feature.

WORKAROUND:

None


STATUS:

The feature has been submitted as an enhancement request to be considered for a future release of Toad for Oracle.


NOTE:

LOG ERRORS is a DML error logging feature introduced in Oracle 10gR2. When a DML (INSERT, UPDATE, MERGE or DELETE) fails the whole statement is rolled back. LOG ERRORS clause attached to a DML enables the statement to competition regardless of error.

For an in-depth study on LOG ERRORS, consult your Oracle 10g text.