ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
I am using the SQL Developer Migration Workbench to migrate 3 databases from SQL Server and currently have the following issues:
1. Migrated procedures are using UTILS procedures such as "utils.handleerror", "convert_to_datetime", "identity_value" and others, however, these procedures does not exist in this package... - Is this a known issue? What is suggested solution? - Perhaps an up-to-date version of the package can be downloaded which contains these?
2. Procedures are using user defined table types from the UDT package. However, this package does not exist and was never created by the tool. For example:
v_newNotifications IN UDT.NEWGROUPNOTIFICATIONSTABLETYPE%TYPE,