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 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.


Didn't find what you were looking for?