Home > IT Answers > Database > Oracle to SQL Server Migration – CURSOR type conversion
Kumar9378
25 pts.
 Oracle to SQL Server Migration – CURSOR type conversion
Database migration, Oracle import/export, SQL Server 2005, SQL Server import/export, SSMA for Oracle
When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

Software/Hardware used:
ASKED: August 22, 2008  1:42 AM
UPDATED: August 25, 2008  2:52 PM
RELATED QUESTIONS
Answer Wiki:
A cursor data type is how Oracle manages recordsets. Usually a cursor contains the result set of a query run in a PL/SQL program. If I remember right, SQL Server T-SQL procedures return results of a query by default. Therefore all you need to do is make sure that the query you want the results from is the last thing executed by the procedure, so the results can be returned correctly. You probably can delete the varchar(8000) variables.
Last Wiki Answer Submitted:  August 25, 2008  2:52 pm  by  Dwaltr   900 pts.
All Answer Wiki Contributors:  Dwaltr   900 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I haven’t used Oracle for a while, what’ is a CURSOR data type?

Denny Cherry
 64,520 pts.