Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
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
-
MDEV-34323 Oracle compatibility project 3
- Open
-
MDEV-34569 Oracle compatibility project 4
- Open
- is blocked by
-
MDEV-34391 SET PATH statement
- In Review