Oracle KUPD$DATA
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 Undocumented
AUTHID CURRENT_USER
Dependencies
DBMS_ASSERT DBMS_SYS_SQL KUPCC
DBMS_DATAPUMP DBMS_UTILITY KUPCLIB
DBMS_ERRLOG KU$_DDL KUPD$DATA_INT
DBMS_LOB KU$_DDLS KUPF$FILE
DBMS_LOGREP_UTIL KU$_DROPCOLLIST KUPP$PROC
DBMS_METADATA KU$_MULTI_DDL KUPUTIL
DBMS_METADATA_DIFF KU$_MULTI_DDLS KUPV$FT
DBMS_METADATA_UTIL KU$_PARSED_ITEM KUPV$FT_INT
DBMS_SESSION KU$_PARSED_ITEMS KUPW$WORKER
DBMS_SQL KU$_VCNT PLITBLM
DBMS_SYS_ERROR    
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/prvthpd.plb
Subprograms
 
DEBUG_ENABLED
Returns 1 if debug is enabled, else 0 kupd$data.debug_enabled RETURN NUMBER;
SELECT kupd$data.debug_enabled
FROM dual;

DEBUG_ENABLED
-------------
            0
 
ET_CREATE_ERROR_TABLE
Creates a DML error logging table that is exactly the same in every respect to the one created by the DBMS_ERRLOG package with the sole exception being the name of the resulting error table. kupd$data.et_create_error_table(
dml_tbl_owner IN VARCHAR2,
dml_tbl_name  IN VARCHAR2,
err_tbl_owner IN VARCHAR2,
err_tbl_name  IN VARCHAR2);
exec kupd$data.et_create_error_table('C##UWCLASS', 'SERVERS', 'C##UWCLASS', 'SRV_ERRS');

PL/SQL procedure successfully completed.

SELECT owner, object_type, created
FROM dba_objects
WHERE object_name = 'SRV_ERRS';

OWNER       OBJECT_TYPE  CREATED
----------- ------------ --------------------
C##UWCLASS  TABLE        13-AUG-2021 21:48:53


desc c##uwclass.srv_errs

Name             Null? Type
---------------- ----- ---------------
ORA_ERR_NUMBER$        NUMBER
ORA_ERR_MESG$          VARCHAR2(2000)
ORA_ERR_ROWID$         ROWID
ORA_ERR_OPTYP$         VARCHAR2(2)
ORA_ERR_TAG$           VARCHAR2(2000)
SRVR_ID                VARCHAR2(4000)
NETWORK_ID             VARCHAR2(4000)
STATUS                 VARCHAR2(4000)
LATITUDE               VARCHAR2(4000)
LONGITUDE              VARCHAR2(4000)
NETADDRESS             VARCHAR2(4000)
 
FETCH_INSERT_STMT
Undocumented kupd$data.fetch_insert_stmt(
schema_name   IN VARCHAR2,
table_name    IN VARCHAR2,
part_name     IN VARCHAR2,
stream_md     IN CLOB,
flags         IN BINARY_INTEGER,
insert_stmt   IN OUT CLOB,
dropped_cols  IN OUT sys.ku$_dropcollist,
unpacked_cols IN OUT sys.ku$_dropcollist,
sqlvalid         OUT BINARY_INTEGER);
TBD
 
OPEN
Undocumented kupd$data.open(
operation       IN VARCHAR2,
schema_name     IN VARCHAR2,
original_schema IN VARCHAR2,
table_name      IN VARCHAR2,
original_table  IN VARCHAR2,
part_name       IN VARCHAR2,
subpart_name    IN VARCHAR2,
metadata        IN CLOB)
RETURN NUMBER;
TBD
 
SET_DEBUG
Undocumented

Protected by an ACCESSIBLE BY clause
kupd$data.set_debug(debug_flags IN BINARY_INTEGER);
exec kupd$data.set_debug(1);
BEGIN kupd$data.set_debug(1); END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object SET_DEBUG
 
SET_PARAMETER
Undocumented

Overload 1
kupd$data.set_parameter(
ctx_h IN NUMBER,
name  IN VARCHAR2,
value IN VARCHAR2);
TBD
Undocumented

Overload 2
kupd$data.set_parameter(
ctx_h  IN NUMBER,
name   IN VARCHAR2,
value  IN VARCHAR2,
value2 IN VARCHAR2);
TBD
Undocumented

Overload 3
kupd$data.set_parameter(
ctx_h IN NUMBER,
name  IN VARCHAR2,
value IN NUMBER);
TBD
 
START_JOB
Undocumented kupd$data.start_job(
ctx_h      IN  NUMBER,
rowcount   OUT NUMBER,
errcount   OUT NUMBER,
charsetid  OUT NUMBER,
ncharsetid OUT NUMBER,
acc_method OUT NUMBER);
DECLARE
 rcOut  NUMBER;
 ecOut  NUMBER;
 csOut  NUMBER;
 ncsOut NUMBER;
 amOut  NUMBER;
BEGIN
  kupd$data.start_job(99, rcOut, ecOut, csOut, ncsOUT, amOut);
  dbms_output.put_line(rcOut);
  dbms_output.put_line(ecOut);
  dbms_output.put_line(csOut);
  dbms_output.put_line(ncsOut);
  dbms_output.put_line(amOut);
END;
/
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "SYS.KUPD$DATA", line 4591
ORA-06512: at "SYS.KUPD$DATA", line 7262
ORA-39096: invalid input value 1 for parameter HANDLE
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPD$DATA", line 1439
ORA-06512: at "SYS.KUPD$DATA", line 6984
ORA-06512: at line 8

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_DATAPUMP
DBMS_DATAPUMP_INT
DBMS_DATAPUMP_UTL
DBMS_ERRLOG
DBMS_MASTER_TABLE
DBMS_PSWMG_IMPORT
KUPCC
KUPD$DATA
PSTDY_DATAPUMP_SUPPORT
TSDP_DATAPUMP
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx