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

Direct access to some objects in this package is prevented by means of an Accessible By clause.
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx