I have a use case where we currently use a Stat workflow to execute data fixes in production. The CSR is only used for approvals and to attach the SQL script file. Once the CSR goes to Prod the SQL is downloaded and executed with SQLPlus.
The script file always contains the number of rows to be updated/inserted/deleted. It is critical that this matches.
Han anyone developed an automated process to execute SQL scripts that validates the execution prior to commit? I have seen automated execution but there is no validation. The SQL syntax is correct, it is important that a script is not committed if the row counts are off.