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

Add support for TYPE .. IS REF CURSOR

Details

    Description

      Implement TYPE .. REF CURSOR.

      REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

      https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

      https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

      Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

      DECLARE
      		 
        TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE;  -- strong type
      		 
        TYPE weak_cursor IS REF CURSOR;                              -- weak type

      The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-20034.

      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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34560 Qualified package data types

          • Major - Major loss of function.
          • Open

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

          • Major - Major loss of function.
          • Open
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-11070 Providing compatibility to other databases - Phase 2

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-35973 Oracle Compatibility Project 1 for 2025

          • Critical - Crashes, loss of data, severe memory leak.
          • In Progress
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33830 Support for cursors on prepared statements

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35979 Oracle: Cursor expressions

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36047 Package body variables are not allowed as FETCH targets

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-36053 CURSOR declarations in PACKAGE BODY

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review

          Activity

            Ascending order - Click to sort in descending order
            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            Epic Link MDEV-10137 [ 56868 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            Epic Link MDEV-10137 [ 56868 ] MDEV-10872 [ 58182 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            bar Alexander Barkov made changes -
            Fix Version/s 10.3 [ 22126 ]
            bar Alexander Barkov made changes -
            Assignee Alexander Barkov [ bar ]
            bar Alexander Barkov made changes -
            Component/s Data types [ 13906 ]
            bar Alexander Barkov made changes -
            Labels Compatibility
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Alexander Barkov [ bar ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility Compatibility Oracle
            julien.fritsch Julien Fritsch made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 75827 ] MariaDB v4 [ 130487 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Description Implement REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets             		Implement REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets


            bar Alexander Barkov made changes -
            Description Implement REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets


            		Implement REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type - we'll be added later

              TYPE weak_cursor IS REF CURSOR; -- weak type - we'll be added later
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-10152.
            bar Alexander Barkov made changes -
            Summary Add support for REF CURSOR Add support for TYPE .. IS REF CURSOR
            bar Alexander Barkov made changes -
            Description Implement REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type - we'll be added later

              TYPE weak_cursor IS REF CURSOR; -- weak type - we'll be added later
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-10152.             		Implement TYPE .. REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type - we'll be added later

              TYPE weak_cursor IS REF CURSOR; -- weak type - we'll be added later
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-10152.
            bar Alexander Barkov made changes -
            Description Implement TYPE .. REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type - we'll be added later

              TYPE weak_cursor IS REF CURSOR; -- weak type - we'll be added later
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-10152.             		Implement TYPE .. REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type - we'll be added later
              TYPE weak_cursor IS REF CURSOR; -- weak type - we'll be added later
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-10152.
            bar Alexander Barkov made changes -
            Description Implement TYPE .. REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type - we'll be added later
              TYPE weak_cursor IS REF CURSOR; -- weak type - we'll be added later
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-10152.             		Implement TYPE .. REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type
              TYPE weak_cursor IS REF CURSOR; -- weak type
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-10152.
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Parent MDEV-19162 [ 74215 ]
            Issue Type Task [ 3 ] Technical task [ 7 ]
            bar Alexander Barkov made changes -
            Epic Link MDEV-10872 [ 58182 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 175219
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Description Implement TYPE .. REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type
              TYPE weak_cursor IS REF CURSOR; -- weak type
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-10152.             		Implement TYPE .. REF CURSOR.

            REF CURSOR is a flexible way to return query results/record sets from stored procedures and functions.

            https://docs.oracle.com/database/121/LNPLS/cursor_variable.htm#LNPLS01312

            https://oracle-base.com/articles/misc/using-ref-cursors-to-return-recordsets

            Under terms of this task we'll implement strong and weak cursor types that need a TYPE definition:

            {code:sql}
            DECLARE
              TYPE storong_cursor IS REF CURSOR RETURN employees%ROWTYPE; -- strong type
              TYPE weak_cursor IS REF CURSOR; -- weak type
            {code}

            The pre-defined SYS_REFCURSOR is out of scope of this task and we'll be implemented under terms of MDEV-20034.
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            julien.fritsch Julien Fritsch made changes -
            Parent MDEV-19162 [ 74215 ]
            Issue Type Technical task [ 7 ] New Feature [ 2 ]
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            adamluciano Adam Luciano made changes -
            Fix Version/s 12.1 [ 29992 ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Alexander Barkov [ bar ]
            julien.fritsch Julien Fritsch made changes -
            Sprint Server 12.1 dev sprint [ 793 ]
            julien.fritsch Julien Fritsch made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            Sprint Server 12.1 dev sprint [ 793 ]

            People

              bar Alexander Barkov
              monty Michael Widenius
              Votes:
              6 Vote for this issue
              Watchers:
              10 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.