Oracle | KUPW$WORKER

Oracle KUPW$WORKER 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 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	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;

      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