Forum Stats

  • 3,825,244 Users
  • 2,260,486 Discussions
  • 7,896,465 Comments

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)

dbms_errlog.set_table_prefs(<ownname>,<tabname>,<log_table>,<reject_limit>)

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.

Tagged:
Rainer StenzelWilliam Robertson
3 votes

Active · Last Updated