Oracle | KUPW$WORKER

Oracle KUPW$WORKER Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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' ORDER BY 1; Returns 91 objects

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

Access to some subpograms prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvthpw.plb

Subprograms

DISPATCH_WORK_ITEMS	GET_REMAP_SCHEMA	REPORT_ERROR_CALLBACK
FETCH_UNLOAD_METHOD	IS_IMPORT_TRANSPORTABLE	SET_DEBUG
GET_CONTAINER_ID	MAIN	SET_OPTION_TRANSFORM_CALLBACK
GET_JOB_VERSION	MARK_BAD_OBJECT_CALLBACK	STREAM_MD_REMAP_SCHEMA
GET_PROXY_VAT_VIEW

DISPATCH_WORK_ITEMS

Undocumented kupw$worker.dispatch_work_items;

exec kupw$worker.dispatch_work_items;

          
      *

      ORA-00900: invalid SQL statement

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(1);

             *

      ORA-00923: FROM keyword not found where expected

GET_CONTAINER_ID

Undocumented kupw$worker.get_container_id RETURN NUMBER;

SELECT kupw$worker.get_container_id;

      

      GET_CONTAINER_ID

      ----------------

                     1

      

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

      

      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');

      

      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;

      

      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);

conn / as sysdba

      

      exec kupw$worker.set_debug(1);

           *

      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