The following rules in Code Analysis are not triggering correctly.
2118 - Avoid DDLs other than Truncate, Exchange/Split partition.
2120 - Avoid SELECT statements with more than two UNION operations
2129 - For a given parenthetical level, avoid more than six OR operations in WHERE clauses
2832 - Avoid hard-coded constraints on VARCHAR2 variables by anchoring the declaration to a variable or column with %TYPE, or by defining a SUBTYPE and then declaring the variable based on that subtype
4213 - Use CASE statement rather than a complex conditional IF statement.
4804 - Avoid use of EXIT/RETURN statements in a FOR/WHILE loop
4809 - A loop that contains DML statements should be refactored to use BULK COLLECT and FORALL
4812 - SELECT BULK COLLECT INTO (implicit bulk query) could cause problems with session memory if too many rows are retrieved. Consider using FETCH BULK COLLECT with LIMIT clause.
5002 - Avoid assigning strings of zero length to character-type variables.
5406 - Remove unused parameter or modify code to use the parameter.
5825 - Consider replacing INSERT/UPDATE or UPDATE/INSERT pairs working on the same table by a MERGE
5917 - Do not use 'Insert into ... select * ...' statements
6811 - Avoid parameters or variables with embedded spaces
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center