Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
10.3.7
-
None
-
CentOS 7.4
Description
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
Attachments
Issue Links
- duplicates
-
MDEV-11210 TYPE OF and %TYPE in stored function RETURN data type
- Open