Forum Stats

  • 3,825,244 Users
  • 2,260,486 Discussions


dml error logging preferences

Rainer Stenzel
Rainer Stenzel Member Posts: 63 Bronze Badge
edited Apr 14, 2021 3:12PM in Database Ideas - Ideas

To enable DML error logging for unchangeable or even unknown cursors a preferences based DML logging feature might be provided.

With (conceptual example)


the dml error log clause

LOG ERRORS INTO <log_table> REJECT LIMIT <reject_limit>

shoud be added to all statements containing <ownname>.<tabname> as a DML target implicitely.

Maybe more preferences could be added to further restrict the impact to less cursors e.g. sql_id or force_matching_signature.

Rainer StenzelWilliam Robertson
3 votes

Active · Last Updated