Oracle | KUPD$DATA

Oracle KUPD$DATA Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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