Bug

Code Rules in Bug category

Category Severity Name Description
Bug Major All branches in a conditional structure should not have exactly the same implementation All branches in a conditional structure should not have exactly the same implementation
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
Bug Major DML events clauses should not include multiple OF clauses DML events clauses should not include multiple OF clauses
Bug Critical END LOOP should be followed by a semicolon END LOOP should be followed by a semicolon
Bug Minor Explicitly opened cursors should be closed Explicitly opened cursors should be closed
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
Bug Major Identical expressions should not be used on both sides of a binary operator Identical expressions should not be used on both sides of a binary operator
Bug Major IF statement conditions should not evaluate unconditionally to TRUE or to FALSE IF statement conditions should not evaluate unconditionally to TRUE or to FALSE
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
Bug Major Jump statements should not be followed by dead code Jump statements should not be followed by dead code
Bug Major Loops with at most one iteration should be refactored Loops with at most one iteration should be refactored
Bug Major MLSLABEL should not be used MLSLABEL should not be used
Bug Critical NCHAR and NVARCHAR2 size in bytes NCHAR and NVARCHAR2 size should not be specified in bytes
Bug Major NULL should not be compared directly NULL should not be compared directly
Bug Critical Nullable subqueries should not be used in NOT IN conditions Nullable subqueries should not be used in NOT IN conditions
Bug Major Output parameters should be assigned Output parameters should be assigned
Bug Critical Overridden Predefined Exceptions Predefined exceptions should not be overridden
Bug Major PACKAGE BODY initialization sections should not contain RETURN statements PACKAGE BODY initialization sections should not contain RETURN statements
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
Bug Critical RAISE_APPLICATION_ERROR should only be used with error codes from -20,000 to - 20,999 RAISE_APPLICATION_ERROR should only be used with error codes from -20,000 to - 20,999
Bug Major Related IF / ELSIF statements and WHEN clauses in a CASE should not have the same condition Related IF / ELSIF statements and WHEN clauses in a CASE should not have the same condition
Bug Major ROWNUM should not be used at the same query level as ORDER BY ROWNUM should not be used at the same query level as ORDER BY
Bug Critical Scale should not be specified for float types Scale should not be specified for float types
Bug Critical String variables with no Size specification Size should be specified for string variables
Bug Major Strings should only be moved to variables or columns which are large enough to hold them Strings should only be moved to variables or columns which are large enough to hold them
Bug Critical SYNCHRONIZE should not be used SYNCHRONIZE should not be used
Bug Critical Syntax Errors Syntax Errors
Bug Critical The number of variables in a FETCH statement should match the number of columns in the cursor The number of variables in a FETCH statement should match the number of columns in the cursor
Bug Major The result_cache hint should be avoided The result_cache hint should be avoided
Bug Major Unary prefix operators should not be repeated Unary prefix operators should not be repeated
Bug Critical Uninitialized NOT NULL Variables NOT NULL variables should be initialized
Bug Major VARCHAR2 and NVARCHAR2 should be used VARCHAR2 and NVARCHAR2 should be used
Bug Major Variables and columns should not be self-assigned Variables and columns should not be self-assigned
Bug Critical Variables Declared multiple times in nested scope Variables should be declared only once in a scope
Bug Critical WHERE Clause DELETE and UPDATE statements should contain WHERE clause
Bug Major WHERE clause conditions should not be contradictory WHERE clause conditions should not be contradictory