Oracle to SQL Server Migration – CURSOR type conversion

25 pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    I haven't used Oracle for a while, what' is a CURSOR data type?
    66,185 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following