Critical

Code Rules in Critical Severity

Category	Severity	Name	Description
Maintainability	Critical	%TYPE and %ROWTYPE should not be used in package specification	%TYPE and %ROWTYPE should not be used in package specification
Maintainability	Critical	A primary key should be specified during table creation	A primary key should be specified during table creation
Maintainability	Critical	Block labels should appear on the same lines as END	Block labels should appear on the same lines as END
Maintainability	Critical	Block start and end labels should match	Block start and end labels should match
Maintainability	Critical	Blocks containing EXECUTE IMMEDIATE should trap all exceptions	Blocks containing EXECUTE IMMEDIATE should trap all exceptions
Maintainability	Critical	CASE expressions should end with ELSE clauses	CASE expressions should end with ELSE clauses
Bug	Critical	Collections should not be iterated in FOR loops	Collections should not be iterated in FOR loops
Bug	Critical	COMMIT and ROLLBACK should not be called from non-autonomous transaction triggers	COMMIT and ROLLBACK should not be called from non-autonomous transaction triggers
Bug	Critical	COMMIT should not be used inside a loop	COMMIT should not be used inside a loop
Bug	Critical	Constant declarations should contain initialization assignments	Constant declarations should contain initialization assignments
Bug	Critical	Constraints should not be applied to types that cannot be constrained	Constraints should not be applied to types that cannot be constrained
Maintainability	Critical	CREATE OR REPLACE should be used instead of CREATE	CREATE OR REPLACE should be used instead of CREATE
Maintainability	Critical	DBMS_OUTPUT.PUT_LINE should not be used	DBMS_OUTPUT.PUT_LINE should not be used
Vulnerability	Critical	DES or 3DES Used	Neither DES (Data Encryption Standard) nor DESede (3DES) should be used
SecurityWarning	Critical	Dynamically executing code is security-sensitive	Dynamically executing code is security-sensitive
Bug	Critical	END LOOP should be followed by a semicolon	END LOOP should be followed by a semicolon
Maintainability	Critical	EXCEPTION_INIT -20,NNN calls should be centralized	EXCEPTION_INIT -20,NNN calls should be centralized
Vulnerability	Critical	Exceptions should not be ignored	Exceptions should not be ignored
Bug	Critical	FETCH ... BULK COLLECT INTO should not be used without a LIMIT clause	FETCH ... BULK COLLECT INTO should not be used without a LIMIT clause
Bug	Critical	FORALL statements should use the SAVE EXCEPTIONS clause	FORALL statements should use the SAVE EXCEPTIONS clause
Bug	Critical	FORMS_DDL('COMMIT') and FORMS_DDL('ROLLBACK') should not be used	FORMS_DDL('COMMIT') and FORMS_DDL('ROLLBACK') should not be used
Bug	Critical	Functions should end with RETURN statements	Functions should end with RETURN statements
Maintainability	Critical	Global public variables should not be defined	Global public variables should not be defined
Maintainability	Critical	GOTO should not be used to jump backwards	GOTO should not be used to jump backwards
Maintainability	Critical	IF statements should not be nested too deeply	IF statements should not be nested too deeply
Maintainability	Critical	IF...ELSEIF constructs should end with ELSE clauses	IF...ELSEIF constructs should end with ELSE clauses
Bug	Critical	Improper constraint forms should not be used	Improper constraint forms should not be used
Bug	Critical	Individual WHERE clause conditions should not be unconditionally true or false	Individual WHERE clause conditions should not be unconditionally true or false
Bug	Critical	Insert statement values not including Non-Null Columns	Insert statements should include values for non-null columns
Maintainability	Critical	INSERT statements should explicitly list the columns to be set	INSERT statements should explicitly list the columns to be set
Maintainability	Critical	LIKE clauses should not be used without wildcards	LIKE clauses should not be used without wildcards
Maintainability	Critical	Lines should not end with trailing whitespaces	Lines should not end with trailing whitespaces
Maintainability	Critical	LOOP ... END LOOP; constructs should be avoided	LOOP ... END LOOP; constructs should be avoided
Maintainability	Critical	Loop start and end labels should match	Loop start and end labels should match
Bug	Critical	NCHAR and NVARCHAR2 size in bytes	NCHAR and NVARCHAR2 size should not be specified in bytes
Maintainability	Critical	Newline and control characters should not be used in string literals	Newline and control characters should not be used in string literals
Bug	Critical	Nullable subqueries should not be used in NOT IN conditions	Nullable subqueries should not be used in NOT IN conditions
Bug	Critical	Overridden Predefined Exceptions	Predefined exceptions should not be overridden
Bug	Critical	Pipelined functions should have at least one PIPE ROW statement and not return an expression	Pipelined functions should have at least one PIPE ROW statement and not return an expression (PLS-00633)
Bug	Critical	Positional and named arguments should not be mixed in invocations	Positional and named arguments should not be mixed in invocations