Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQL Server to Oracle Migration overview.

Ispirer SQLWays Database Migration Software

Cursor Declaration Conversion from Microsoft SQL Server to Oracle

a) Converting the FORWARD_ONLY cursor

The FORWARD_ONLY option in Microsoft SQL Server specifies that rows scrolled in forward direction from the first to the last row. This scrolling is default in Oracle, so the FORWARD_ONLY option is removed by SQLWays.

Examples:

TABLE 44. Cursor declaration statements in various databases

Microsoft SQL Server	Oracle
DECLARE cur1 CURSOR FORWARD_ONLY FOR SELECT col1 FROM tab1	CURSOR cur1 IS SELECT col1 FROM tab1;

b) Converting SCROLL cursor

The SCROLL option in Microsoft SQL Server specifies that rows scrolled in various directions (FIRST, LAST, PRIOR, NEXT, RELATIVE, ABSOLUTE). Whereas Oracle supports only forward direction (NEXT).

SQLWays removes the SCROLL option when converting to Oracle. This declaration conversion is correct if an application uses fetch with NEXT, otherwise the application must be revised.

Examples:

TABLE 45. Converting SCROLL cursor

Microsoft SQL Server	Oracle
DECLARE cur1 CURSOR SCROLL FOR SELECT col1 FROM tab1	CURSOR cur1 IS SELECT col1 FROM tab1;