Cursor Variables
Translation reference for cursor variables and the OPEN FOR statement
Description
A cursor variable is like an explicit cursor that is not limited to one query.
(Oracle PL/SQL Language Reference Cursor Variable Declaration)
Snowflake Scripting has no direct equivalence with cursor variables and the OPEN FOR
statement, however, they can be emulated with different workarounds to get functional equivalence.
Sample Source Patterns
1. OPEN FOR statement with dynamic SQL inside a VARCHAR variable
2. OPEN FOR statement with dynamic SQL inside a string literal.
3. OPEN FOR statement with SELECT statement
4. Cursor Variable declared with REF CURSOR type
5. OPEN FOR statement with USING clause
Known Issues
No issues were found.
Related EWIs
MSCEWI3133: Cursor variable has already been assigned.
MSCEWI3109: Expressions as arguments of Using Clause are not supported by Snowflake Scripting.
MSCEWI1036: Data type converted to another data type.
MSCEWI1058: Functionality is not currently supported by Snowflake Scripting.
MSCCP0004: The statement below has usages of dynamic SQL.
Last updated