Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17057

%TYPE not working for function return values

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              karlsson Anders Karlsson
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: