CURSOR DECLARATION
Notice that this statement is removed from the migration because it is a non-relevant syntax. It means that it is not required in Snowflake.
Description
This section explains the translation of the declaration of cursors in Oracle. For more information review the following documentation about procedures and cursors in Oracle.
Sample Source Patterns
CURSOR DECLARATION
Notice that in this example the CURSOR
statement has been deleted. This is a non-relevant syntax in the transformation targeted to Snowflake.
CREATE PROCEDURE PROC_COLLECTIONS
AS
CURSOR C2 RETURN T1%TYPE;
BEGIN
NULL;
END
CREATE OR REPLACE PROCEDURE PROC_COLLECTIONS ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
EXECUTE AS CALLER
AS
$$
BEGIN
NULL;
END;
$$;
Last updated