0 Replies Latest reply on Jun 10, 2015 5:35 PM by 1297545

    SQL Developer Migration Workbench UTILS and UDT packages

    1297545

      Hi,

      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,

       

      Any help will be much appreciated.

       

      Regards,