Release Notes - 1.0

  • 1.0.9-funcrel
    Adds Business Criterion 60018 “Cloud Migration”.
  • 1.0.8-funcrel
    Resolves a performance problem in the link-creation step for an Oracle source file.
  • 1.0.7-funcrel
    Fixes error raised during installation : “Duplicated categories are: SQLToCloud_Metric_SQLServerAzureSQL”.
  • 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
    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
    Fixes Engineering Dashboard visibility for all migration rules.
  • 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
    Fixes an issue causing DB2 specific rules to be erroneously triggered on SQL Server object types.
  • 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
    Moved to funcrel. No code changes have been made.
  • 1.0.0-beta9
    Imaging Advisor - Move Oracle DB to Oracle Cloud shows Mainframe application is using Db2.
    Removed false positives for SMALLINT datatype. 💎 1106074
    Removed false positives for CHAR datatype. 💎 1106084
  • 1.0.0-beta8
    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. 💎 1106176
    NEW “Ensure GENERATED AS IDENTITY is not used”. The rule applies to SQL Tables. 💎 1106174
    NEW “Ensure CCSID num column clause is not used”. The rule applies to SQL Tables. 💎 1106172
    NEW “Ensure CCSID ASCII | UNICODE | EBCDIC column clause is not used”. The rule applies to SQL Tables. 💎 1106170
    NEW “Ensure FOR SBCS | MIXED DATA column clause is not used”. The rule applies to SQL Tables. 💎 1106168
    NEW “Ensure FOR BIT DATA column clause is not used”. The rule applies to SQL Tables. 💎 1106166
    NEW “Ensure CHAR(n) with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106164
    NEW “Ensure DATE with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106162
    NEW “Ensure DECIMAL(p, s) with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106160
    NEW “Ensure INTEGER with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106158
    NEW “Ensure NUMERIC(p, s) with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106156
    NEW “Ensure VARCHAR(n) with implicit default values is not used”. The rule applies to SQL Tables. 💎 1106154
    NEW “Ensure TIMESTAMP data type is not used”. The rule applies to SQL Tables / Views / Procedures / Functions / Triggers, DML script files and Embedded SQL. 💎 1106152
    NEW “Ensure SYSIBM.SYSDUMMY1 table is not used”. The rule applies to SQL Procedures / Functions / Triggers, DML script files and Embedded SQL. 💎 1106150
    NEW “Ensure VALUES statement is not used”. The rule applies to SQL Procedures / Functions / Triggers, DML script files and Embedded SQL. 💎 1106148
    Added support for “Migrate DB2 to MySQL” advisor rules.New advisor: Migrate DB2 to MySQL
  • 1.0.0-beta7
    “Ensure DATETIMEOFFSET data type is not used” - fixes rule scope. 💎 1106130
    “Ensure NCHAR data type is not used” - fixes rule scope. 💎 1106128
    “Ensure NTEXT data type is not used” - fixes rule scope. 💎 1106126
    “Ensure NVARCHAR data type is not used” - fixes rule scope. 💎 1106124
    “Ensure ROWVERSION data type is not used” - fixes rule scope. 💎 1106122
    “Ensure SMALLMONEY data type is not used” - fixes rule scope. 💎 1106120
    “Ensure TIMESTAMP data type is not used” - fixes rule scope. 💎 1106118
    “Ensure TINYINT data type is not used” - fixes rule scope. 💎 1106116
    “Ensure VARBINARY data type is not used” - fixes rule scope. 💎 1106114
  • 1.0.0-beta6
    NEW Ensure SQL Server DECLARE variable is not used 💎 1106146
    NEW Ensure SQL Server SET/SELECT variable is not used 💎 1106144
    NEW Ensure IDENTITY Columns is not used 💎 1106142
    NEW Ensure SQL server Scalar Function ISNULL is not used 💎 1106140
    NEW Ensure SQL server Scalar Function GETDATE is not used 💎 1106138
    NEW Ensure SQL server Scalar Function DATEDIFF is not used 💎 1106136
    NEW Ensure SQL server Scalar Function DATEADD is not used 💎 1106134
    NEW Ensure SQL server Scalar Function CONVERT is not used 💎 1106132
    NEW Ensure DATETIMEOFFSET data type is not used 💎 1106130
    NEW Ensure NCHAR data type is not used 💎 1106128
    NEW Ensure NTEXT data type is not used 💎 1106126
    NEW Ensure ROWVERSION data type is not used 💎 1106122
    NEW Ensure SMALLMONEY data type is not used 💎 1106120
    NEW Ensure TIMESTAMP data type is not used 💎 1106118
    NEW Ensure TINYINT data type is not used 💎 1106116
    NEW Ensure VARBINARY data type is not used 💎 1106114
    Changed title and description. 💎 1106108
    Changed title and description. 💎 1106102
  • 1.0.0-beta5
    NEW Ensure FROM keyword is used in DELETE Statement. 💎 1106112
    NEW Ensure MERGE statement is not used. 💎 1106110
    NEW Ensure SET variable Statement is not used. 💎 1106108
    NEW Ensure VALUES statement is not used. 💎 1106106
    NEW Ensure SYSIBM.SYSDUMMY1 table is not used. 💎 1106104
    NEW Ensure DECLARE variable is not used. 💎 1106102
    NEW Ensure DECLARE cursor is not used. 💎 1106100
    NEW Ensure CASE Expression is not used. 💎 1106098
    NEW Ensure PARTITION is not used in ALTER TABLE statements. 💎 1106096
  • 1.0.0-beta4
    NEW Ensure PL/SQL packages UTL_MAIL and UTL_SMTP are not used 💎 1106044
    NEW Ensure CREATE FUNCTION is not used 💎 1106046
    NEW Ensure CREATE PROCEDURE is not used 💎 1106048
    NEW Ensure CREATE TRIGGER is not used 💎 1106050
    NEW Ensure BLOB data type is not used 💎 1106052
    NEW Ensure CLOB data type is not used 💎 1106054
    NEW Ensure DBCLOB data type is not used 💎 1106056
    NEW Ensure VARCHAR(n) FOR BIT DATA data type is not used 💎 1106058
    NEW Ensure NVARCHAR data type is not used 💎 1106060
    NEW Ensure NCHAR data type is not used 💎 1106062
    NEW Ensure NCHAR VARYING data type is not used 💎 1106064
    NEW Ensure GRAPHIC data type is not used 💎 1106066
    NEW Ensure FLOAT data type is not used 💎 1106068
    NEW Ensure DECFLOAT data type is not used 💎 1106070
    NEW Ensure DB2 Scalar Function DATE is not used 💎 1106072
    NEW Ensure DB2 Scalar Function SMALLINT is not used 💎 1106074
    NEW Ensure DB2 Scalar Function LCASE is not used 💎 1106076
    NEW Ensure DB2 Scalar Function POSSTR is not used 💎 1106078
    NEW Ensure DB2 Scalar Function RAND is not used 💎 1106080
    NEW Ensure DB2 Scalar Function TIMESTAMP is not used 💎 1106082
    NEW Ensure DB2 Scalar Function CHAR is not used 💎 1106084
    NEW Ensure DB2 Scalar Function CONCAT is not used 💎 1106086
    NEW Ensure DB2 Scalar Function YEAR is not used 💎 1106088
    NEW Ensure DB2 Scalar Function MONTH is not used 💎 1106090
    NEW Ensure DB2 Scalar Functions DAY/DAYS are not used 💎 1106092
    NEW Ensure DB2 Scalar Functions DECIMAL/DEC are not used 💎 1106094
    Changed technical criteria from “Cloud Migration - Oracle Database to Amazon Aurora” to “Database Migration - Oracle Database to PostgreSQL” 💎 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
  • 1.0.0-beta3
    NEW New rule added: “Ensure Invisible Index is not used”. 💎 1106042
    NEW New rule added: “Ensure READ ONLY Table is not used”. 💎 1106040
    NEW New rule added: “Ensure Unused Column is not used”. 💎 1106038
  • 1.0.0-beta2
    Fixed violation bookmark for objects with multiple bookmarks.
    Title updated from “Ensure you don’t have unsupported PL/SQL packages” to “Ensure unsupported PL/SQL packages are not used”. 💎 1106000
    Title updated from “Ensure you replace Oracle Merge” to “Ensure MERGE statement is not used”. 💎 1106002
    Title updated from “Ensure you don’t have unsupported PL/SQL package UTL_FILE” to “Ensure PL/SQL package UTL_FILE is not used”. 💎 1106006
    Title updated from “Ensure you don’t have unsupported PL/SQL package DBMS_SCHEDULER” to “Ensure PL/SQL package DBMS_SCHEDULER is not used”. 💎 1106008
    Title updated from “Ensure you don’t have unsupported PL/SQL package DBMS_RANDOM” to “Ensure PL/SQL package DBMS_RANDOM is not used”. 💎 1106010
    Title updated from “Ensure you don’t have unsupported PL/SQL package DBMS_OUTPUT” to “Ensure PL/SQL package DBMS_OUTPUT is not used”. 💎 1106012
    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”. 💎 1106014
    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”. 💎 1106016
    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”. 💎 1106018
    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”. 💎 1106022
    Title updated from “Ensure you don’t have unsupported XMLType columns in tables” to “Ensure XMLType columns are not used”. 💎 1106026
    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”. 💎 1106028
    Title updated from “Ensure you don’t have unsupported ROWID data type and pseudocolumn” to “Ensure ROWID data type is not used”. 💎 1106032
    Title updated from “Ensure you don’t have unsupported Database Links” to “Ensure Database Links are not used”. 💎 1106036
  • 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.
    NEW “Ensure you don’t have unsupported Database Links”. This rule checks if database link objects exist or are referenced in Oracle Database(s). 💎 1106036
    NEW “Ensure EXTERNAL TABLEs are not used”. This rule checks the usage of EXTERNAL TABLEs in Oracle Database(s). 💎 1106034
    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). 💎 1106032
    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). 💎 1106030
    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). 💎 1106028
    NEW “Ensure you don’t have unsupported XMLType columns in tables”. This rule checks if any table contains XMLType columns in Oracle Database(s). 💎 1106026
    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). 💎 1106024
    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). 💎 1106022
    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. 💎 1106020
    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). 💎 1106018
    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). 💎 1106016
    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). 💎 1106014
    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). 💎 1106012
    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). 💎 1106010
    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). 💎 1106008
    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). 💎 1106006
    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. 💎 1106004
    NEW “Ensure you replace Oracle Merge”. This rule checks if the Oracle MERGE Statement is used. 💎 1106002
    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). 💎 1106000