Oracle | KUPD$DATA

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	OPEN	SET_PARAMETER
ET_CREATE_ERROR_TABLE	SET_DEBUG	START_JOB
FETCH_INSERT_STMT

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