Using %TYPE for a return value from a PL/SQL function fails with MariaDB, but works as expected in Oracle. Like this:

DROP TABLE tab1;

CREATE TABLE tab1(c1 INTEGER);

CREATE OR REPLACE FUNCTION f1

  RETURN tab1.c1%TYPE

AS

BEGIN

   RETURN 1;

END;

/

With Oracle this works without errors. With MariaDB I get:
ERROR 1064 (42000) at line 1 in file...

%TYPE declarations works for function and procedure parameters in both Oracle and MariaDB