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

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

          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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36053 Syntax error on a CURSOR..IS declaration in PACKAGE BODY

          • Major - Major loss of function.
          • Open

          Activity

            There are no comments yet on this issue.

            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.