Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10764 PL/SQL parser - Phase 2
  3. MDEV-12034

Dynamic SQL in stored functions

    XMLWordPrintable

Details

    Description

      Currently dynamic SQL (prepared statements and EXECUTE IMMEDIATE) can be used within stored procedures, but not in stored functions or triggers. Oracle supports dynamic SQL in stored functions. We'll allow dynamic SQL in stored functions at least for sql_mode=ORACLE.

      Attachments

        Issue Links

          is duplicated by

          Task - A task that needs to be done. MDEV-8618 DYNAMIC SQL in stored functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              Unassigned Unassigned
              bar Alexander Barkov
              Votes:
              9 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.