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; /
References
- same as plsql:LabelSubBlock
- same as Trivadis G-1010