Code Analysis

BP015

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.

Available in

SQL Prompt

SQL Code Guard

 


Didn't find what you were looking for?