locked
SSMA - O2SS0005: The source datatype 'table1%ROWTYPE' was not recognized. RRS feed

  • Question

  • I have a Packaged Funtion as follows:

    CREATE OR REPLACE FUNCTION f_get_command (
          package_in   IN  table1.table1_package%TYPE,
          proc_in      IN   table1.table1_function%TYPE
       )
          RETURN table1.table1_function%TYPE
       IS
          table1_rec   table1%ROWTYPE;
       BEGIN
         ...
       END f_get_command;

    When migrating the above using SSMA for Oracle V6, I get the error "".

    But, I have a public synonym that has be migrated into the SQL Server Metadata, as follows:

    CREATE SYNONYM ssma_oracle.TABLE1 FOR CONV_GENERAL.GENERAL.TABLE1

    Why can't SSMA resolve the ROWTYPE statement for table1?

    Saturday, September 19, 2015 7:26 PM

All replies