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

System package SYS.DBMS_SQL

Details

    Description

      Add a subset of the system package SYS.DBMS_SQL:

      • Functions DBMS_SQL.OPEN_CURSOR - overloaded
      • Procedure DBMS_SQL.CLOSE_CURSOR

      https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sql.htm#i996963

      "The DBMS_SQL package provides an interface to use dynamic SQL to parse any data manipulation language (DML) or data definition language (DDL) statement using PL/SQL. For example, you can enter a DROP TABLE statement from within a stored procedure by using the PARSE procedure supplied with the DBMS_SQL package."

      We can provide a package on install that calls our parsing functions.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34323 Oracle compatibility project 3

          • Major - Major loss of function.
          • Open
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34391 SET PATH statement

          • Critical - Crashes, loss of data, severe memory leak.
          • Needs Feedback

          Activity

            Ascending order - Click to sort in descending order
            manjot Manjot Singh (Inactive) created issue -
            ralf.gebhardt Ralf Gebhardt made changes -
            Field Original Value New Value
            Labels Compatibility
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 97163 ] MariaDB v4 [ 141311 ]
            bar Alexander Barkov made changes -
            Description https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sql.htm#i996963

            "The DBMS_SQL package provides an interface to use dynamic SQL to parse any data manipulation language (DML) or data definition language (DDL) statement using PL/SQL. For example, you can enter a DROP TABLE statement from within a stored procedure by using the PARSE procedure supplied with the DBMS_SQL package."

            We can provide a package on install that calls our parsing functions.

            		Add a subset of the system package SYS.DBMS_SQL:
            - Functions DBMS_SQL.OPEN_CURSOR - overloaded
            - Procedure DBMS_SQL.CLOSE_CURSOR

            https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sql.htm#i996963

            "The DBMS_SQL package provides an interface to use dynamic SQL to parse any data manipulation language (DML) or data definition language (DDL) statement using PL/SQL. For example, you can enter a DROP TABLE statement from within a stored procedure by using the PARSE procedure supplied with the DBMS_SQL package."

            We can provide a package on install that calls our parsing functions.

            bar Alexander Barkov made changes -
            Summary sql_mode="oracle" should provide dbms_sql System package SYS.DBMS_SQL
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            serg Sergei Golubchik made changes -
            Parent MDEV-19162 [ 74215 ]
            Issue Type Technical task [ 7 ] New Feature [ 2 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility Compatibility Oracle
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Minor [ 4 ]

            People

              Unassigned Unassigned
              manjot Manjot Singh (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.