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

 

This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved


Didn't find what you were looking for?