Oracle KUPW$WORKER
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 SELECT name FROM dba_dependencies WHERE referenced_name = 'KUPW$WORKER'
UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'KUPW$WORKER';

-- this query returns 90 rows
Documented No
Exceptions
Error Code Reason
ORA-39126 Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS []
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvthpw.plb
Subprograms
 
DISPATCH_WORK_ITEMS
Undocumented kupw$worker.dispatch_work_items;
exec kupw$worker.dispatch_work_items;
BEGIN kupw$worker.dispatch_work_items; END;
*
ERROR at line 1:
ORA-00900: invalid SQL statement
ORA-06512: at "SYS.KUPW$WORKER", line 30523
ORA-06512: at "SYS.KUPW$WORKER", line 30456
ORA-06512: at "SYS.KUPW$WORKER", line 35511
ORA-06512: at "SYS.KUPW$WORKER", line 13417
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS []
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 13383
ORA-06512: at "SYS.KUPW$WORKER", line 14824
ORA-00900: invalid SQL statement
ORA-06512: at "SYS.KUPW$WORKER", line 14401
ORA-06512: at line 1
 
FETCH_UNLOAD_METHOD
Undocumented

A fascinating error because the "FROM" keyword, in the explicit select is clearly where it should be.
kupw$worker.fetch_unload_method(po_num IN NUMBER) RETURN NUMBER;
SELECT kupw$worker.fetch_unload_method(42) FROM dual;
SELECT kupw$worker.fetch_unload_method(42) FROM dual
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
ORA-06512: at "SYS.KUPW$WORKER", line 36531
 
GET_CONTAINER_ID
Undocumented kupw$worker.get_container_id RETURN NUMBER;
SELECT kupw$worker.get_container_id
FROM dual;

GET_CONTAINER_ID
----------------
               1


SELECT sys_context('USERENV', 'CON_ID')
FROM dual;

SYS_CONTEXT('USERENV','CON_ID')
--------------------------------
1
 
GET_JOB_VERSION
Undocumented kupw$worker.get_job_version(version OUT VARCHAR2);
DECLARE
  outVal dbms_id;
BEGIN
  kupw$worker.get_job_version(outVal);
  dbms_output.put_line(outVal);
END;
/

PL/SQL procedure successfully completed.
 
GET_PROXY_VAT_VIEW
Undocumented kupw$worker.get_proxy_vat_view(
proxy_schema OUT VARCHAR2,
proxy_view   OUT VARCHAR2);
DECLARE
 outSchema all_objects.owner%TYPE;
 outView   all_objects.object_name%TYPE;
BEGIN
  kupw$worker.get_proxy_vat_view(outSchema, outView);
  dbms_output.put_line(outSchema);
  dbms_output.put_line(outView);
END;
/

PL/SQL procedure successfully completed.
 
GET_REMAP_SCHEMA
Undocumented kupw$worker.get_remap_schema(old_schema IN VARCHAR2) RETURN VARCHAR2;
SELECT kupw$worker.get_remap_schema('UWCLASS')
FROM dual;

KUPW$WORKER.GET_REMAP_SCHEMA('UWCLASS')
----------------------------------------
C##UWCLASS
 
IS_IMPORT_TRANSPORTABLE
Undocumented kupw$worker.is_import_transportable RETURN BINARY_INTEGER;
SELECT kupw$worker.is_import_transportable
FROM dual;

IS_IMPORT_TRANSPORTABLE
-----------------------
                      0
 
MAIN
Undocumented kupw$worker.main(
master_name   IN VARCHAR2,
master_owner  IN VARCHAR2,
debug_info    IN BINARY_INTEGER,
ena_sec_roles IN NUMBER);
TBD
 
MARK_BAD_OBJECT_CALLBACK
Undocumented kupw$worker.mark_bad_object_callback(
object_type IN VARCHAR2,
object_schema IN VARCHAR2,
object_name IN VARCHAR2);
exec kupw$worker.mark_bad_object_callback('TABLE', 'C##UWCLASS', 'ZZYZX');

PL/SQL procedure successfully completed.
 
REPORT_ERROR_CALLBACK
Undocumented kupw$worker.report_error_callback(err_str IN VARCHAR2);
exec kupw$worker.report_error_callback('No Error');

PL/SQL procedure successfully completed.
 
SET_DEBUG
Undocumented

This procedures is protected by an ACCESSIBLE BY clause
kupw$worker.set_debug(debug_flags IN BINARY_INTEGER);
exec kupw$worker.set_debug(1);
BEGIN kupw$worker.set_debug(1); END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object SET_DEBUG
 
SET_OPTION_TRANSFORM_CALLBACK
Undocumented kupw$worker.set_option_transform_callback(
name      IN VARCHAR2,
old_value IN VARCHAR2,
value_t   IN VARCHAR2,
value_n   IN NUMBER,
value_b   IN BOOLEAN);
TBD
 
STREAM_MD_REMAP_SCHEMA
Undocumented kupw$worker.stream_md_remap_schema(
str_md_clob        IN     CLOB,
remapped_clob      IN OUT CLOB,
master_table_name  IN     VARCHAR2,
master_table_owner IN     VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_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