Using %TYPE for a return value from a PL/SQL function fails with MariaDB, but works as expected in Oracle. Like this:
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