rules repository

G-7910 – Never use DML within a SQL macro.

Doing DML (except for `select`) within a SQL macro can lead to disastrous side effects from calling the macro in a SQL query. Logging macro calls via a call to a procedure that does DML in an autonomous transaction can be an exception to the rule.

Tags: Stored Object.

Quality area: Reliability. Severity: Blocker. Fixing time: Local-medium.

No rule selected