Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with CURSOR

Issue 6639: MySQL doesn't support the direction clause

MySQL doesn't support the following direction clauses when using FETCH with cursors:

  • ABSOLUTE 2

  • BACKWARD

  • FIRST FROM

  • FORWARD

  • LAST FROM

  • PRIOR FROM

  • RELATIVE 2

  • RELATIVE 3

Perform a manual conversion in these cases.

Issue 6640: MySQL doesn't support the MOVE option

Revise your code to eliminate cursors with the MOVE option.

Issue 6638: MySQL doesn't support the SCROLL option in cursors

Revise your code to eliminate cursors with the SCROLL option.

Issue 6337: MySQL doesn't support a variable of REFCURSOR type

Try revising the code to use temporary tables instead.

Related Topics