This EWI is deprecated, please refer to the MSCINF0026 documentation.
Severity
Medium
Description
Snowflake Scripting Cursors are non-scrollable. Currently, only FETCH NEXT is supported.
Code Example
Input Code:
CREATEORALTERPROCEDURE scrollablecursorTestASBEGIN-- Should be marked with MSCEWI4037DECLARE CursorVar CURSORSCROLLSTATICREAD_ONLYFORSELECT FirstNameFROM vEmployee;-- Should not be markedDECLARE CursorVar2 CURSORSTATICREAD_ONLYFORSELECT FirstNameFROM vEmployee;DECLARE CursorVar3 CURSORFORWARD_ONLYSTATICREAD_ONLYFORSELECT FirstNameFROM vEmployee;RETURN'DONE';END;
Output Code:
CREATEORREPLACEPROCEDURE PUBLIC.scrollablecursorTest ()RETURNSVARCHARLANGUAGESQLEXECUTEASCALLERAS$$DECLARE-- Should be marked with MSCEWI4037/*** MSC-ERROR - MSCEWI4037 - SNOWFLAKE SCRIPTING CURSORS ARE NON-SCROLLABLE, ONLY FETCH NEXT IS SUPPORTED ***/ CursorVar CURSORFORSELECT FirstNameFROM PUBLIC.vEmployee;-- Shouid not be marked CursorVar2 CURSORFORSELECT FirstNameFROM PUBLIC.vEmployee; CursorVar3 CURSORFORSELECT FirstNameFROM PUBLIC.vEmployee;BEGINRETURN'DONE';END;$$;"