G-6010: Always use a character variable to execute dynamic SQL.
Major
Maintainability, Testability
Reason
Having the executed statement in a variable makes it easier to debug your code (e.g. by logging the statement that failed).
Example (bad)
1 2 3 4 5 6 |
|
Example (good)
1 2 3 4 5 6 7 8 |
|