locked
SSMA Warning: Value of @@FETCH_STATUS might change RRS feed

  • Question

  • Hello,

    I get following 4 warnings approx. 200 times when I migrate a database (which contains procedures, functions and tables) from oracle to SQL using SSMA.

    Please suggest what corrective actions I need to take in order to resolve these warning messages.

    O2SS0113: SQL Server Migration Assistant for Oracle Warning message: Value of @@FETCH_STATUS might change(6)

    O2SS0273: SQL Server Migration Assistant for Oracle Warning message: Oracle SUBSTR function and SQL Server SUBSTRING function may give different results(171)

    O2SS0356: SQL Server Migration Assistant for Oracle Warning message: Conversion from NUMBER datatype can cause data loss(179)

    O2SS0452: SQL Server Migration Assistant for Oracle Warning message: Call to "xp_ora2ms_exec2_ex" from within UDF.(5)

    Thanks a lot for your help!!

    Thursday, April 2, 2015 7:27 AM

Answers