Published 16 November 2017
Scope of cursor (LOCAL/GLOBAL) is not specified
You have not explicitly defined the scope of a cursor.
When you define a cursor with the DECLARE CURSOR statement you can, and should, define the scope of the cursor name. GLOBAL means that the cursor name should be global to the connection. LOCAL specifies that the cursor name is LOCAL to the stored procedure, trigger, or batch containing the DECLARE CURSOR statement.