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

System package SYS.DBMS_LOB

    XMLWordPrintable

Details

    Description

      Implement a subset of the system package SYS.DBMS_LOB:

      • Procedure DBMS_LOB.APPEND - overloaded
      • Function DBMS_LOB.SUBSTR - overloaded
      • Procedure DBMS_LOB.CREATETEMPORARY - overloaded
      • Procedure DBMS_LOB.GETLENGTH - overloaded
      • Function DBMS_LOB.READ - overloaded

      Using a BLOB variable as a handle should be supported:

      CREATE TABLE t1 (a BLOB);
      		 
      INSERT INTO t1 VALUES (utl_raw.cast_to_raw('test'));
      		 
      DECLARE
      		 
        va BLOB;
      		 
        buffer RAW(1);
      		 
        len INTEGER;
      		 
        amount INTEGER:= 1;
      		 
        pos INTEGER :=1;
      		 
      BEGIN
      		 
        SELECT a INTO va FROM t1;
      		 
        len:= DBMS_LOB.getlength(va);
      		 
        WHILE pos <= len
      		 
        LOOP
      		 
          DBMS_LOB.READ(va, amount, pos, buffer);
      		 
          DBMS_OUTPUT.PUT_LINE(utl_raw.cast_to_varchar2(buffer));
      		 
          pos:= pos + 1;
      		 
        END LOOP;
      		 
      END;


      t
      		 
      e
      		 
      s
      		 
      t

      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-34569 Oracle compatibility project 4

          • 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

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

          Activity

            People

              Unassigned Unassigned
              bar Alexander Barkov
              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.