Release Notes - 1.0
-
1.0.9-funcrel
1.0.9-funcrel
Adds Business Criterion 60018 “Cloud Migration”. -
1.0.8-funcrel
1.0.8-funcrel
Resolves a performance problem in the link-creation step for an Oracle source file. -
1.0.7-funcrel
1.0.7-funcrel
Fixes error raised during installation : “Duplicated categories are: SQLToCloud_Metric_SQLServerAzureSQL”. -
1.0.6-funcrel
1.0.6-funcrel
Adds migration rule SQL Server to Azure SQL : 💎 1106292 - Ensure AgentJobs is not used Adds migration rule SQL Server to Azure SQL : 💎 1106326 - Ensure BEGIN DISTRIBUTED TRANSACTION is not used Adds migration rule SQL Server to Azure SQL : 💎 1106324 - Ensure BULK INSERT Using Non-Azure Blob Sources is not used Adds migration rule SQL Server to Azure SQL : 💎 1106322 - Ensure COMPATIBILITY_LEVEL is not less than 100 Adds migration rule SQL Server to Azure SQL : 💎 1106320 - Ensure COMPUTE Clause is not used Adds migration rule SQL Server to Azure SQL : 💎 1106318 - Ensure CrossDatabaseReferences is not used Adds migration rule SQL Server to Azure SQL : 💎 1106316 - Ensure DISABLE_DEF_CNST_CHK is not used Adds migration rule SQL Server to Azure SQL : 💎 1106314 - Ensure Database Mail is not used Adds migration rule SQL Server to Azure SQL : 💎 1106312 - Ensure FASTFIRSTROW is not used Adds migration rule SQL Server to Azure SQL : 💎 1106310 - Ensure FILESTREAM is not used Adds migration rule SQL Server to Azure SQL : 💎 1106308 - Ensure LinkedServer is not used Adds migration rule SQL Server to Azure SQL : 💎 1106306 - Ensure NEXT is not used as table or column name Adds migration rule SQL Server to Azure SQL : 💎 1106304 - Ensure NonANSILeftOuterJoinSyntax *= operator is not used Adds migration rule SQL Server to Azure SQL : 💎 1106302 - Ensure NonANSIRightOuterJoinSyntax =* operator is not used Adds migration rule SQL Server to Azure SQL : 💎 1106300 - Ensure OpenRowsetWithNonBlobDataSourceBulk is not used Adds migration rule SQL Server to Azure SQL : 💎 1106298 - Ensure OpenRowsetWithSQLAndNonSQLProvider is not used Adds migration rule SQL Server to Azure SQL : 💎 1106296 - Ensure RAISERROR is not used Adds migration rule SQL Server to Azure SQL : 💎 1106294 - Ensure SQL CLR assemblies are not used Adds migration rule SQL Server to Azure SQL : 💎 1106290 - Ensure ServerScopedTriggers is not used Adds migration rule SQL Server to Azure SQL : 💎 1106284 - Ensure TraceFlags is not used -
1.0.5-funcrel
1.0.5-funcrel
Fixes incorrect bookmarks. Adds migration rule SQL Server to Azure SQL : 💎 1106282 - Ensure SYS.DATABASE_PRINCIPAL_ALIASES is not used Adds migration rule SQL Server to Azure SQL : 💎 1106288 - Ensure SqlMail is not used Adds migration rule SQL Server to Azure SQL : 💎 1106286 - Ensure SystemProcedures110 is not used Adds migration rule SQL Server to Azure SQL : 💎 1106280 - Ensure XpCmdshell is not used 1.0.4-funcrel
1.0.4-funcrel
Fixes Engineering Dashboard visibility for all migration rules. 1.0.3-funcrel
1.0.3-funcrel
Add new database migration rule from Db2 to Oracle : 💎 1106246 - Ensure Db2 Data Type CHARACTER VARYING(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106240 - Ensure Db2 Data Type DOUBLE [PRECISION] is not used Add new database migration rule from Db2 to Oracle : 💎 1106234 - Ensure Db2 Data Type VARCHAR(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106236 - Ensure Db2 Data Type NUMERIC(p,s) | NUM(p,s) is not used Add new database migration rule from Db2 to Oracle : 💎 1106238 - Ensure Db2 Data Type INTEGER, INT is not used Add new database migration rule from Db2 to Oracle : 💎 1106244 - Ensure Db2 Data Type DECFLOAT(16 | 34) is not used Add new database migration rule from Db2 to Oracle : 💎 1106242 - Ensure Db2 Data Type DECIMAL(p,s) | DEC(p,s) is not used Add new database migration rule from Db2 to Oracle : 💎 1106232 - Ensure Db2 Data Type CHAR(n) FOR BIT DATA is not used Add new database migration rule from Db2 to Oracle : 💎 1106226 - Ensure Db2 Data Type VARCHAR(n) FOR BIT DATA is not used Add new database migration rule from Db2 to Oracle : 💎 1106230 - Ensure Db2 Data Type VARGRAPHIC(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106228 - Ensure Db2 Data Type NVARCHAR(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106224 - Ensure Db2 Data Type NCHAR VARYING(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106222 - Ensure Db2 Data Type GRAPHIC(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106220 - Ensure Db2 Data Type FLOAT(p) is not used Add new database migration rule from Db2 to Oracle : 💎 1106218 - Ensure Db2 Data Type NCLOB(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106216 - Ensure Db2 Data Type DBCLOB(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106214 - Ensure Db2 Data Type CLOB(n) is not used Add new database migration rule from Db2 to Oracle : 💎 1106212 - Ensure Db2 Data Type TIME is not used Add new database migration rule from Db2 to Oracle : 💎 1106210 - Ensure Db2 Data Type SMALLINT is not used Add new database migration rule from Db2 to Oracle : 💎 1106208 - Ensure Db2 Data Type REAL is not used Add new database migration rule from Db2 to Oracle : 💎 1106204 - Ensure Db2 Data Type BIGINT is not used Add new database migration rule from Db2 to Oracle : 💎 1106206 - Ensure Db2 Data Type XML is not used Add new database migration rule from Db2 to Oracle : 💎 1106202 - Ensure Db2 Scalar Function CONCAT is not used Add new database migration rule from Db2 to Oracle : 💎 1106200 - Ensure Db2 Data Type RESULT_SET_LOCATOR is not used Add new database migration rule from Db2 to Oracle : 💎 1106198 - Ensure Db2 NEXTVAL | NEXT VALUE FOR seq_name is not used Add new database migration rule from Db2 to Oracle : 💎 1106196 - Ensure Db2 Built-in Function CURRENT DATE is not used Add new database migration rule from Db2 to Oracle : 💎 1106194 - Ensure Db2 Built-in Function CHAR_LENGTH(string) is not used Add new database migration rule from Db2 to Oracle : 💎 1106192 - Ensure Db2 Built-in Function CHARACTER_LENGTH(string) is not used Add new database migration rule from Db2 to Oracle : 💎 1106190 - Ensure Db2 Built-in Function CHAR(string, num) is not used Add new database migration rule from Db2 to Oracle : 💎 1106188 - Ensure Db2 Built-in Function CHAR(date, USA) is not used Add new database migration rule from Db2 to Oracle : 💎 1106186 - Ensure Db2 Built-in Function CEILING(num) is not used Add new database migration rule from Db2 to Oracle : 💎 1106184 - Ensure Db2 Built-in Function BLOB(exp [,size]) is not used Add new database migration rule from Db2 to Oracle : 💎 1106182 - Ensure Db2 Built-in Function BIGINT(exp) is not used Add new database migration rule from Db2 to Oracle : 💎 1106180 - Ensure Db2 Built-in Function ATANH(exp) is not used Add new database migration rule from Db2 to Oracle : 💎 1106178 - Ensure Db2 Built-in Function ABSVAL is not used Add new database migration rule from Db2 to SQL Server : 💎 1106248 - Ensure BLOB data type is not used Add new database migration rule from Db2 to SQL Server : 💎 1106252 - Ensure DBCLOB data type is not used Add new database migration rule from Db2 to SQL Server : 💎 1106250 - Ensure NCLOB data type is not used Add new database migration rule from Db2 to SQL Server : 💎 1106254 - Ensure GRAPHIC data type is not used Add new database migration rule from Db2 to SQL Server : 💎 1106256 - Ensure FOR BIT DATA statement is not used Add new database migration rule from Db2 to SQL Server : 💎 1106258 - Ensure TIMESTAMP data type is not used Add new database migration rule from Db2 to SQL Server : 💎 1106264 - Ensure SYSIBM.SYSDUMMY1 table is not used Add new database migration rule from Db2 to SQL Server : 💎 1106260 - Ensure Db2 Scalar Function CURRENT DATE is not used Add new database migration rule from Db2 to SQL Server : 💎 1106262 - Ensure Db2 Scalar Function LCASE is not used Add new database migration rule from Db2 to SQL Server : 💎 1106266 - Ensure NUM data type is not used Add new database migration rule from Db2 to SQL Server : 💎 1106274 - Ensure Converting numeric function INT(string) is not used Add new database migration rule from Db2 to SQL Server : 💎 1106272 - Ensure Converting numeric function SMALLINT(expr) is not used Add new database migration rule from Db2 to SQL Server : 💎 1106268 - Ensure Db2 Scalar Function LEAST is not used Add new database migration rule from Db2 to SQL Server : 💎 1106270 - Ensure Db2 Scalar Function GREATEST is not used Add new database migration rule from Db2 to SQL Server : 💎 1106276 - Ensure FOR READ ONLY is not used in SELECT statement Add new database migration rule from Db2 to SQL Server : 💎 1106278 - Ensure CREATE OR REPLACE PROCEDURE name statement is not used 1.0.2-funcrel
1.0.2-funcrel
Fixes an issue causing DB2 specific rules to be erroneously triggered on SQL Server object types. 1.0.1-funcrel
1.0.1-funcrel
Added set_local.sql file to ensure that when the extension is installed the specific SQL SETs are available. 1.0.0-funcrel
1.0.0-funcrel
Moved to funcrel. No code changes have been made.1.0.0-beta9
1.0.0-beta9
Imaging Advisor - Move Oracle DB to Oracle Cloud shows Mainframe application is using Db2. 1.0.0-beta8
1.0.0-beta8
💎 1106176 NEW “Ensure DB2 Built-in Function CURRENT DATE is not used”. The rule applies to SQL Tables / Views / Procedures / Functions / Triggers, DML script files and Embedded SQL. 💎 1106174 NEW “Ensure GENERATED AS IDENTITY is not used”. The rule applies to SQL Tables. 💎 1106172 NEW “Ensure CCSID num column clause is not used”. The rule applies to SQL Tables. 💎 1106170 NEW “Ensure CCSID ASCII | UNICODE | EBCDIC column clause is not used”. The rule applies to SQL Tables. 💎 1106168 NEW “Ensure FOR SBCS | MIXED DATA column clause is not used”. The rule applies to SQL Tables. 💎 1106166 NEW “Ensure FOR BIT DATA column clause is not used”. The rule applies to SQL Tables. 💎 1106164 NEW “Ensure CHAR(n) with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106162 NEW “Ensure DATE with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106160 NEW “Ensure DECIMAL(p, s) with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106158 NEW “Ensure INTEGER with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106156 NEW “Ensure NUMERIC(p, s) with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106154 NEW “Ensure VARCHAR(n) with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106152 NEW “Ensure TIMESTAMP data type is not used”. The rule applies to SQL Tables / Views / Procedures / Functions / Triggers, DML script files and Embedded SQL. 💎 1106150 NEW “Ensure SYSIBM.SYSDUMMY1 table is not used”. The rule applies to SQL Procedures / Functions / Triggers, DML script files and Embedded SQL. 💎 1106148 NEW “Ensure VALUES statement is not used”. The rule applies to SQL Procedures / Functions / Triggers, DML script files and Embedded SQL. New advisor: Migrate DB2 to MySQL Added support for “Migrate DB2 to MySQL” advisor rules. 1.0.0-beta7
1.0.0-beta7
💎 1106130 “Ensure DATETIMEOFFSET data type is not used” - fixes rule scope. 💎 1106128 “Ensure NCHAR data type is not used” - fixes rule scope. 💎 1106126 “Ensure NTEXT data type is not used” - fixes rule scope. 💎 1106124 “Ensure NVARCHAR data type is not used” - fixes rule scope. 💎 1106122 “Ensure ROWVERSION data type is not used” - fixes rule scope. 💎 1106120 “Ensure SMALLMONEY data type is not used” - fixes rule scope. 💎 1106118 “Ensure TIMESTAMP data type is not used” - fixes rule scope. 💎 1106116 “Ensure TINYINT data type is not used” - fixes rule scope. 💎 1106114 “Ensure VARBINARY data type is not used” - fixes rule scope. 1.0.0-beta6
1.0.0-beta6
💎 1106146 NEW Ensure SQL Server DECLARE variable is not used 💎 1106144 NEW Ensure SQL Server SET/SELECT variable is not used 💎 1106142 NEW Ensure IDENTITY Columns is not used 💎 1106140 NEW Ensure SQL server Scalar Function ISNULL is not used 💎 1106138 NEW Ensure SQL server Scalar Function GETDATE is not used 💎 1106136 NEW Ensure SQL server Scalar Function DATEDIFF is not used 💎 1106134 NEW Ensure SQL server Scalar Function DATEADD is not used 💎 1106132 NEW Ensure SQL server Scalar Function CONVERT is not used 💎 1106130 NEW Ensure DATETIMEOFFSET data type is not used 💎 1106128 NEW Ensure NCHAR data type is not used 💎 1106126 NEW Ensure NTEXT data type is not used 💎 1106122 NEW Ensure ROWVERSION data type is not used 💎 1106120 NEW Ensure SMALLMONEY data type is not used 💎 1106118 NEW Ensure TIMESTAMP data type is not used 💎 1106116 NEW Ensure TINYINT data type is not used 💎 1106114 NEW Ensure VARBINARY data type is not used 💎 1106108 Changed title and description. 💎 1106102 Changed title and description. 1.0.0-beta5
1.0.0-beta5
💎 1106112 NEW Ensure FROM keyword is used in DELETE Statement. 💎 1106110 NEW Ensure MERGE statement is not used. 💎 1106108 NEW Ensure SET variable Statement is not used. 💎 1106106 NEW Ensure VALUES statement is not used. 💎 1106104 NEW Ensure SYSIBM.SYSDUMMY1 table is not used. 💎 1106102 NEW Ensure DECLARE variable is not used. 💎 1106100 NEW Ensure DECLARE cursor is not used. 💎 1106098 NEW Ensure CASE Expression is not used. 💎 1106096 NEW Ensure PARTITION is not used in ALTER TABLE statements. 1.0.0-beta4
1.0.0-beta4
💎 1106044 NEW Ensure PL/SQL packages UTL_MAIL and UTL_SMTP are not used 💎 1106046 NEW Ensure CREATE FUNCTION is not used 💎 1106048 NEW Ensure CREATE PROCEDURE is not used 💎 1106050 NEW Ensure CREATE TRIGGER is not used 💎 1106052 NEW Ensure BLOB data type is not used 💎 1106054 NEW Ensure CLOB data type is not used 💎 1106056 NEW Ensure DBCLOB data type is not used 💎 1106058 NEW Ensure VARCHAR(n) FOR BIT DATA data type is not used 💎 1106060 NEW Ensure NVARCHAR data type is not used 💎 1106062 NEW Ensure NCHAR data type is not used 💎 1106064 NEW Ensure NCHAR VARYING data type is not used 💎 1106066 NEW Ensure GRAPHIC data type is not used 💎 1106068 NEW Ensure FLOAT data type is not used 💎 1106070 NEW Ensure DECFLOAT data type is not used 💎 1106072 NEW Ensure DB2 Scalar Function DATE is not used 💎 1106074 NEW Ensure DB2 Scalar Function SMALLINT is not used 💎 1106076 NEW Ensure DB2 Scalar Function LCASE is not used 💎 1106078 NEW Ensure DB2 Scalar Function POSSTR is not used 💎 1106080 NEW Ensure DB2 Scalar Function RAND is not used 💎 1106082 NEW Ensure DB2 Scalar Function TIMESTAMP is not used 💎 1106084 NEW Ensure DB2 Scalar Function CHAR is not used 💎 1106086 NEW Ensure DB2 Scalar Function CONCAT is not used 💎 1106088 NEW Ensure DB2 Scalar Function YEAR is not used 💎 1106090 NEW Ensure DB2 Scalar Function MONTH is not used 💎 1106092 NEW Ensure DB2 Scalar Functions DAY/DAYS are not used 💎 1106094 NEW Ensure DB2 Scalar Functions DECIMAL/DEC are not used 💎 1106002 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106006 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106008 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106010 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106012 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106014 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106020 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106022 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106034 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106036 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106038 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106040 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106042 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 1106044 Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 1.0.0-beta2
1.0.0-beta2
Fixed violation bookmark for objects with multiple bookmarks. 💎 1106000 Title updated from “Ensure you don’t have unsupported PL/SQL packages” to “Ensure unsupported PL/SQL packages are not used”. 💎 1106002 Title updated from “Ensure you replace Oracle Merge” to “Ensure MERGE statement is not used”. 💎 1106006 Title updated from “Ensure you don’t have unsupported PL/SQL package UTL_FILE” to “Ensure PL/SQL package UTL_FILE is not used”. 💎 1106008 Title updated from “Ensure you don’t have unsupported PL/SQL package DBMS_SCHEDULER” to “Ensure PL/SQL package DBMS_SCHEDULER is not used”. 💎 1106010 Title updated from “Ensure you don’t have unsupported PL/SQL package DBMS_RANDOM” to “Ensure PL/SQL package DBMS_RANDOM is not used”. 💎 1106012 Title updated from “Ensure you don’t have unsupported PL/SQL package DBMS_OUTPUT” to “Ensure PL/SQL package DBMS_OUTPUT is not used”. 💎 1106014 Title updated from “Ensure you don’t have unsupported PL/SQL package DBMS_AUTO_INDEX” to “Ensure PL/SQL package DBMS_AUTO_INDEX is not used”. 💎 1106016 Title updated from “Ensure you don’t have unsupported PL/SQL packages UTL_HTTP and UTL_SMTP” to “Ensure PL/SQL packages UTL_HTTP and UTL_SMTP are not used”. 💎 1106018 Title updated from “Ensure you don’t have unsupported PL/SQL procedures DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE” to “Ensure PL/SQL procedures DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE are not used”. 💎 1106022 Title updated from “Ensure you don’t have unsupported option GENERATED BY DEFAULT for identity columns” to “Ensure GENERATED BY DEFAULT option for identity columns is not used”. 💎 1106026 Title updated from “Ensure you don’t have unsupported XMLType columns in tables” to “Ensure XMLType columns are not used”. 💎 1106028 Title updated from “Ensure you don’t have unsupported clause CLUSTER in CREATE TABLE statements” to “Ensure CLUSTER clause in CREATE TABLE statements is not used”. 💎 1106032 Title updated from “Ensure you don’t have unsupported ROWID data type and pseudocolumn” to “Ensure ROWID data type is not used”. 💎 1106036 Title updated from “Ensure you don’t have unsupported Database Links” to “Ensure Database Links are not used”. 1.0.0-beta1
1.0.0-beta1
Initial release of the extension providing a dedicated set of quality rules that have been designed to help plan a modernization project for taking an on premise RDBMS to the Cloud (Oracle Cloud / Amazon Aurora). These quality rules are in addition to the SQL quality rules provided by the SQL Analyzer and AIP Core.💎 1106036 NEW “Ensure you don’t have unsupported Database Links”. This rule checks if database link objects exist or are referenced in Oracle Database(s). 💎 1106034 NEW “Ensure EXTERNAL TABLEs are not used”. This rule checks the usage of EXTERNAL TABLEs in Oracle Database(s). 💎 1106032 NEW “Ensure you don’t have unsupported ROWID data type and pseudocolumn”. This rule checks the usage of ROWID data type and ROWID pseudocolumn in Oracle Database(s). 💎 1106030 NEW “Ensure INDEX-ORGANIZED TABLEs (IOT) are not used”. This rule checks the usage of ORGANIZATION INDEX clause in the CREATE TABLE statement in Oracle Database(s). 💎 1106028 NEW “Ensure you don’t have unsupported clause CLUSTER in CREATE TABLE statements”. This rule checks the usage of CLUSTER clause in the CREATE TABLE statement in Oracle Database(s). 💎 1106026 NEW “Ensure you don’t have unsupported XMLType columns in tables”. This rule checks if any table contains XMLType columns in Oracle Database(s). 💎 1106024 NEW “Ensure you don’t have unsupported clause SHARDED in CREATE TABLE statements”. This rule checks the usage of SHARDED clause in CREATE TABLE statements for Oracle Database(s). 💎 1106022 NEW “Ensure you don’t have unsupported option GENERATED BY DEFAULT for identity columns”. This rule checks if tables with identity columns have the GENERATED BY DEFAULT option in Oracle Database(s). 💎 1106020 NEW “Ensure LOB data types are not used”. This rule checks the usage of LOB Storage in Oracle Database(s) and the explicit conversion functions TO_CLOB and TO_NCLOB which convert other data types to LOB data types. 💎 1106018 NEW “Ensure you don’t have unsupported PL/SQL procedures DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE”. This rule checks if the DBMS_LOGMNR.ADD_LOGFILE and DBMS_LOGMNR.REMOVE_LOGFILE procedures are used in Oracle Database(s). 💎 1106016 NEW “Ensure you don’t have unsupported PL/SQL packages UTL_HTTP and UTL_SMTP”. This rule checks if the UTL_HTTP or UTL_SMTP PL/SQL packages are used in Oracle Database(s). 💎 1106014 NEW “Ensure you don’t have unsupported PL/SQL package DBMS_AUTO_INDEX”. This rule checks the usage of the DBMS_AUTO_INDEX package in Oracle Database(s). 💎 1106012 NEW “Ensure you don’t have unsupported PL/SQL package DBMS_OUTPUT”. This rule checks the usage of the DBMS_OUTPUT package in Oracle Database(s). 💎 1106010 NEW “Ensure you don’t have unsupported PL/SQL package DBMS_RANDOM”. This rule checks the usage of the DBMS_RANDOM package in the Oracle Database(s). 💎 1106008 NEW “Ensure you don’t have unsupported PL/SQL package DBMS_SCHEDULER.” This rule checks the usage of the DBMS_SCHEDULER package in the Oracle Database(s). 💎 1106006 NEW “Ensure you don’t have unsupported PL/SQL package UTL_FILE”. This rule checks the usage of the UTL_FILE package in the Oracle Database(s). 💎 1106004 NEW “Ensure CLOB data type is not used”. This rule checks the usage of CLOB Storage and the explicit conversion function TO_CLOB which converts other data types to CLOB. 💎 1106002 NEW “Ensure you replace Oracle Merge”. This rule checks if the Oracle MERGE Statement is used. 💎 1106000 NEW “Ensure you don’t have unsupported PL/SQL packages”. This rule checks if UTL_TCP, UTL_INADDR, DBMS_LDAP, DBMS_DEBUG, DBMS_DEBUG_JDWP, DBMS_DEBUG_JDWP_CUSTOM PL/SQL packages are used in Oracle Database(s).