Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work
  3. MDEV-10152

Add support for TYPE .. IS REF CURSOR

    XMLWordPrintable

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
          relates to

          Technical task - A technical task. MDEV-20034 Add support for the pre-defined weak SYS_REFCURSOR

          • Major - Major loss of function.
          • Open

          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

          Activity

            People

              Unassigned Unassigned
              monty Michael Widenius
              Votes:
              6 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.