You can change table audit settings using the settings_write_string procedure.
To set the table settings to fully audit insert and update operations but ignore any delete operations, use the following code with Oracle:
exec settings_write_string('330','database.audit.TASK','Options');
To set the table settings to fully audit insert and update operations but ignore any delete operations, use the following code with Microsoft SQL Server:
exec settings_write_string '330','database.audit.TASK','Options'
Note: Changes to auditing settings will not appear immediately in the application. The program will need to close the database connection and then reconnect to the database to get the new settings.
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, September 30, 2016