New rule: Never user DML within a SQL macro.

[PhilippSalvisberg]

Inspired by this tweet: https://twitter.com/connor_mc_d/status/1466006049333211137?s=20 by @connormcd

select could make sense in some use cases. Maybe also some logging as part of an autonomous transactions, to see when a macro is executed. All other use of DML statements are questionable.

[connormcd]

Amen .... I think allowing it is a poor choice by us. Connor McDonald =========================== email: ***@***.*** blog: connor-mcdonald.com twitter: connor_mc_d On Wednesday, 1 December 2021, 08:06:24 pm AWST, Philipp Salvisberg ***@***.***> wrote: Inspired by this tweet: https://twitter.com/connor_mc_d/status/1466006049333211137?s=20 by @connormcd select could make sense in some use cases. Maybe also some logging as part of an autonomous transactions, to see when a macro is executed. All other use of DML statements are questionable. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android.