Oracle to SQL Server Using SSMA - O2SS0083 Unresolved identifier

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

Answer 1

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

Answer 2

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

Answer 3

can you take a picture of that