Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
dml error logging preferences

Rainer Stenzel
Member Posts: 63 Bronze Badge
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.