locked
Oracle to SQL Server Using SSMA - O2SS0083 Unresolved identifier RRS feed

  • Question

  • Hi All,

    Trying to migrate Oracle db to SQL Server using SSMA V5.2, but getting several errors:

    -------------------------------------------------

    SSMA error messages:

    O2SS0083: Identifier DBMs_SQL.OPEN_CURSOR cannot be converted because it was not resolved.

    SET @curHandler = DBMS_SQL.OPEN_CURSOR

    ---------------------------------------------------

    This error goes on for DBMS_SQL.PARSE,  DBMS_SQL.EXECUTE, and DBMS_SQL.CLOSE_CURSOR. What are the SQL server equivalent of these Oracle operations?

     Any help you can provide would be greatly appreciated!

    Thank you,

    Grace
    Wednesday, February 13, 2013 7:25 PM

All replies

  • Hello,

    Those operations belong to cursors in Oracle. You will find examples of cursors in T-SQL on the following resources:

    http://msdn.microsoft.com/en-us/library/ms181441.aspx

    http://msdn.microsoft.com/en-us/library/ms180169.aspx

    You will find in these resources the equivalent of each Oracle operation.

    Hope this helps

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, February 13, 2013 11:19 PM
  • Thank you Alberto!

    In SSMA, after creating report, it shows both Oracle SQL code and SQL Server conversion code side by side, you can copy/save the Oracle source code nicely, but  how do you copy/save the SQL Server side conversion code to a text file without the line number in front of each line? I've tried several ways, still couldn't get a clean copy of the code. Does any one know how?

    Thanks,

    Grace

    Thursday, February 14, 2013 6:58 PM
  • can you take a picture of that
    Wednesday, February 20, 2013 8:34 AM