i migrated an entire oracle Database to SQL Server 2014 Database using SSMA. (SQL Server Migration assistant)
The migration resulted in introduction of multiple Execution calls in my stored procedures (like below):
The module 'INFRA_IP_WEBLOGGER$spCheckIPStatus' depends on the missing object 'sysdb.ssma_oracle.db_check_init_package'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'INFRA_IP_WEBLOGGER$spCheckIPStatus' depends on the missing object 'sysdb.ssma_oracle.db_error_exact_one_row_check'. The module will still be created; however, it cannot run successfully until the object exists.
where INFRA_IP_WEBLOGGER$spCheckIPStatus is one of the Procedure name.
Do i have to install some seperate component so that SQL Server 2014 detects call to sysdb.ssma_oracle
What can i do to fix these errors?
SSMA relies on some stored procedures added to your SQL Server instance. Look at the manual for "Extension Pack" installation. Something for older version of SSMA is here on MSDN: Installing SSMA Components on SQL Server (OracleToSQL) , but use the manual and extension pack for your specific SSMA version.