sql_mode=ORACLE: Variable declarations can go after cursor declarations

DROP TABLE t1;

DROP FUNCTION f1;

CREATE TABLE t1 (a INT);

INSERT INTO t1 VALUES (1);

CREATE FUNCTION f1 RETURN INT

AS

  CURSOR c IS SELECT a FROM t1;

  v_a INT;

BEGIN

  OPEN c;

  FETCH c INTO v_a;

  CLOSE c;

  RETURN v_a;

EXCEPTION

  WHEN OTHERS THEN RETURN -1;

END;

/

SELECT f1() FROM DUAL;

      F1()

----------

	 1