G-1010
🆓Warning
Try to label your sub blocks.
Reason
It's a good alternative for comments to indicate the start and end of a named processing.
Example
Non-Compliant Example
begin
begin
null;
end;
begin
null;
end;
end;
/Issues
| Line | Column | Message |
|---|---|---|
| 2 | 4 | |
| 4 | 4 | |
| 6 | 4 | |
| 8 | 4 |
Compliant Solution - ★★★★★
begin
<<prepare_data>>
begin
null;
end prepare_data;
<<process_data>>
begin
null;
end process_data;
end good;
/Parameters
Use parameters to customize the rule to your needs.
| Parameter | Description | Default Value |
|---|---|---|
| DisableAllQuickFix | Comma-separated list of rules for which a quick fix should not be applied to all the problems in a file. | Core G-3130 |
References
- same as Trivadis G-1010
- same as plsql:LabelSubBlock