Tuesday, August 4, 2009

O2SS0259: CURSOR type was converted to varchar(8000).

SQL Server returns cursors in different way than Oracle. SSMA converts cursor parameter to a VARCHAR parameter to keep procedure parameter count, but converts OPEN FOR statement inside stored procedure into a SELECT statement. This works in most cases when procedure is called from outside (client application).
In general, you can safely ignore this warning, because all places which require attention because of this migration issue (passing a cursor as a parameter) are marked with other errors with proper “migration hours” assigned.

More Information

Applies to
• SSMA 2005 for Oracle
• SSMA 2008 for Oracle

No comments:

Post a Comment