Oracle DBMS_DUMA_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Database Unicode Migration Assistant. This package is intended to support the Database Migration Assistant GUI first available with Oracle 12c.
AUTHID CURRENT_USER
Data Types TYPE dukl_detect_columns IS ...

TYPE dukl_detect_result_table IS TABLE OF ...

TYPE dukl_detect_rowids IS ...
Dependencies
DUMA_LIB PLITBLM  
Documented Yes, but not in the Packages and Types documentation.

https://www.oracle.com/database/technologies/dmu-gettingstarted.html
First Available 12.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtdumi.plb
SQL> @?/rdbms/admin/prvtdumi.plb

Library created.

SP2-0808: Package created with compilation warnings

Errors for PACKAGE SYS.DBMS_DUMA_INTERNAL:

LINE/COL ERROR
------------------------------------------------------------------------
18/3 PLW-06010: keyword "LANGUAGE" used as a defined name

SP2-0810: Package Body created with compilation warnings

Errors for PACKAGE BODY SYS.DBMS_DUMA_INTERNAL:

LINE/COL ERROR
------------------------------------------------------------------------
35/14 PLW-07203: parameter 'RESULT_TABLE' may benefit from use of the
NOCOPY compiler hint

87/3 PLW-07206: analysis suggests that the assignment to
'RESULT_TABLE' may be unnecessary

116/3 PLW-07206: analysis suggests that the assignment to
'RESULT_TABLE' may be unnecessary

145/3 PLW-07206: analysis suggests that the assignment to
'RESULT_TABLE' may be unnecessary
Subprograms
 
CONVERT_LONG
Undocumented dbms_duma_internal.convert_long(
target_table_id IN NUMBER,
source_table_id IN NUMBER,
buffer_size     IN NUMBER,
ddbcs_id        IN NUMBER,
rows_to_commit  IN NUMBER,
start_rowid     IN ROWID,
end_rowid       IN ROWID,
flags           IN VARCHAR2);
TBD
 
DETECT_LANGUAGE_ENCODING
Undocumented

Overload 1
dbms_duma_internal.detect_language_encoding(
obj_id         IN NUMBER,
list_columns   IN sys.dbms_duma_internal.dukl_detect_columns,
flags          IN VARCHAR2
detect_profile IN NUMBER,
buffer_size    IN NUMBER,
num_results    IN NUMBER,
sampling_size  IN NUMBER)
RETURN sys.dbms_duma_internal.dukl_detect_result_table;
TBD
Undocumented

Overload 2
dbms_duma_internal.detect_language_encoding(obj_id IN NUMBER
list_columns   IN sys.dbms_duma_internal.dukl_detect_columns,
list_rowids    IN sys.dbms_duma_internal.dukl_detect_rowids,
detect_profile IN NUMBER,
buffer_size    IN NUMBER,
num_results    IN NUMBER,
sampling_size  IN NUMBER)
RETURN sys.dbms_duma_internal.dukl_detect_result_table;
TBD
Undocumented

Overload 3
dbms_duma_internal.detect_language_encoding(
obj_id         IN NUMBER,
list_columns   IN sys.dbms_duma_internal.dukl_detect_columns,
start_rowid    IN ROWID,
end_rowid      IN ROWID,
detect_profile IN NUMBER,
buffer_size    IN NUMBER,
num_results    IN NUMBER,
sampling_size  IN NUMBER)
RETURN sys.dbms_duma_internal.dukl_detect_result_table;
TBD
 
GET_PROPERTY
Undocumented dbms_duma_internal.get_property(property_index IN NUMBER) RETURN NUMBER;
SELECT dbms_duma_internal.get_property(1)
FROM dual;

DBMS_DUMA_INTERNAL.GET_PROPERTY(1)
----------------------------------
                                 5


SELECT dbms_duma_internal.get_property(2)
FROM dual;
SELECT dbms_duma_internal.get_property(2)
       *
ERROR at line 1:
ORA-62010: invalid argument: PROPERTY_INDEX
ORA-06512: at "SYS.DBMS_DUMA_INTERNAL", line 310
ORA-06512: at "SYS.DBMS_DUMA_INTERNAL", line 325
 
READ_LONG_TO_BLOB
Undocumented dbms_duma_internal.read_long_to_blob(
owner_name  IN VARCHAR2,
table_name  IN VARCHAR2,
column_name IN VARCHAR2,
row_id      IN ROWID,
buffer_size IN NUMBER)
RETURN BLOB;
DECLARE
 cVar CLOB;
BEGIN
  cVar := dbms_metadata_util.long2clob(120, 'TRIGGER$', 'ACTION#', 'AAAAEoAABAAAAopAAA');
END;
/
META:00:20:50.696: exception from 'SELECT ACTION# FROM TRIGGER$ WHERE ROWID = :1' for rowid value AAAAEoAABAAAAopAAA : ORA-31600: invalid input value TRIGGER$ for parameter TAB in
function UTL_XML.LONG2CLOB
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.UTL_XML", line 195
----- PL/SQL Call Stack -----
object line object
handle
number name
0x1283e3910 767 package body SYS.DBMS_METADATA_UTIL.LONG2CLOB
0x1238f5d88 4 anonymous block

PL/SQL procedure successfully completed.


DECLARE
 bVal BLOB;
BEGIN
  bVal := dbms_duma_internal.read_long_to_blob('SYS', 'TRIGGER$', 'ACTION#', 'AAAAEoAABAAAAopAAA');
END;
/

PL/SQL procedure successfully completed.
 
SCAN_TABLE
Undocumented dbms_duma_internal.scan_table(
table_id    IN NUMBER,
scan_id     IN NUMBER,
buffer_size IN NUMBER,
ddbcs_id    IN NUMBER,
start_rowid IN ROWID,
end_rowid   IN ROWID,
flags       IN VARCHAR2);
TBD
 
WRITE_BLOB_TO_LONG
Undocumented dbms_duma_internal.write_blob_to_long(
source_lob  IN BLOB,
owner_name  IN VARCHAR2,
table_name  IN VARCHAR2,
column_name IN VARCHAR2,
row_id      IN ROWID,
buffer_size IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_LOB
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx