Oracle KUPP$PROC

Oracle KUPP$PROC 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 DataPump Support Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_STATS	KUPF$FILE
DBMS_AW_EXP	DBMS_TDE_TOOLKIT	KUPM$MCP
DBMS_DATAPUMP	DBMS_TRAN_LIB	KUPP_PROC_LIB
DBMS_DATAPUMP_INT	DBMS_TTS	KUPU$UTILITIES
DBMS_DST	KUPC$QUEUE	KUPU$UTILITIES_INT
DBMS_METADATA	KUPC$QUEUE_INT	KUPUTIL
DBMS_METADATA_UTIL	KUPC$QUE_INT	KUPV$FT
DBMS_PLUGTS	KUPCC	KUPV$FT_INT
DBMS_PRIV_CAPTURE	KUPD$DATA	KUPW$WORKER

Documented No

First Available 10.1

Security Model Owned by SYS with execute granted to the EXECUTE_CATALOG_ROLE role.

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

Subprograms

ANY_DEBUG_TRACE_INFO	GET_NLS_ALTER_SESSION	SET_REMOTE_WORKER
APPLY_TRACE_DEBUG_RULES	GET_TRACE_DEBUG	SET_TRACE_DEBUG
CHANGE_USER	GET_WORKER_EXCEPTION	SHUTDOWN_IN_PROGRESS
CHECK_FOR_INTERRUPT	INIT_DONE	TOTAL_WORKERS_ALIVE
CHECK_WORKER_STATUS	IS_MULTIPROCESS_ENABLED	WHATS_MY_ID
CREATE_MASTER_PROCESS	JOB_ALIVE	WHATS_MY_NAME
CREATE_WORKER_PROCESSES	KILL_WORKER	WHAT_AM_I
DEFAULT_DOP	MAX_DOP	WHAT_ORACLE_PRODUCT
DELETE_WORKER_PROCESSES	OPTION_ENABLED	WORKER_EXTTBL_ACTIVE
DISABLE_MULTIPROCESS	SEC_TT_LOADED	WORKER_EXTTBL_FULLNAME
ENABLE_FLASHBACK_DMLS	SEC_TT_UNLOADED	WORKER_EXTTBL_INACTIVE
ENABLE_MULTIPROCESS	SET_CIT_FLAG	WORKER_PROCESS_INIT
GET_CIT_FLAG	SET_PROFILING	WORKER_SERVICE_INIT

ANY_DEBUG_TRACE_INFO

Returns TRUE if any debug trace information has been generated kupp$proc.any_debug_trace_info RETURN BOOLEAN;

set serveroutput on

      

      BEGIN

        IF kupp$proc.any_debug_trace_info THEN

          dbms_output.put_line('TRUE');

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

      
      FALSE

      

      PL/SQL procedure successfully completed.

APPLY_TRACE_DEBUG_RULES

Undocumented kupp$proc.apply_trace_debug_rules(debug_flags IN BINARY_INTEGER) RETURN BINARY_INTEGER;

SELECT kupp$proc.apply_trace_debug_rules(-1)

      FROM dual;

      

      KUPP$PROC.APPLY_TRACE_DEBUG_RULES(-1)

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

                                 -1.074E+09

      

      SELECT kupp$proc.apply_trace_debug_rules(0)

      FROM dual;

      

      KUPP$PROC.APPLY_TRACE_DEBUG_RULES(0)

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

                                         0

      

      SELECT kupp$proc.apply_trace_debug_rules(1)

      FROM dual;

      

      KUPP$PROC.APPLY_TRACE_DEBUG_RULES(1)

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

                                         1

CHANGE_USER

Undocumented but allow changing the user's identity. Requires the BECOME USER privilege kupp$proc.change_user(username IN VARCHAR2);

SELECT user FROM dual;

      

      USER

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

      SYS

      

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

      

      SYS_CONTEXT('USERENV','CURRENT_SCHEMA')

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

      SYS

      

      exec sys.kupp$proc.change_user('UWCLASS');

      *

      ERROR at line 1:

      ORA-31625: Schema UWCLASS is needed to import this object, but is unaccessible

      ORA-06512: at "SYS.KUPP$PROC", line 45

      ORA-06512: at "SYS.KUPP$PROC", line 930

      ORA-06512: at line 1

CHECK_FOR_INTERRUPT

Undocumented kupp$proc.check_for_interrupt;

exec kupp$proc.check_for_interrupt;

      

      PL/SQL procedure successfully completed.

CHECK_WORKER_STATUS

Undocumented and protected by an ACCESIBLE BY Clause kupp$proc.check_worker_status;

exec kupp$proc.check_worker_status;

           *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object CHECK_WORKER_STATUS

CREATE_MASTER_PROCESS

Undocumented kupp$proc.create_master_process( master_exec_spec IN VARCHAR2, username IN VARCHAR2, job_name IN VARCHAR2, wait_init_done IN BOOLEAN) RETURN BINARY_INTEGER;

TBD

CREATE_WORKER_PROCESSES

Undocumented kupp$proc.create_worker_processes( num_workers IN BINARY_INTEGER, worker_exec_spec IN VARCHAR2, worker_seed IN BINARY_INTEGER, wait_init_done IN BOOLEAN) RETURN BINARY_INTEGER;

TBD

DEFAULT_DOP (new 21c)

Undocumented

Protected by an ACCESSIBLE BY clause kupp$proc.default_dop RETURN BINARY_INTEGER;

SELECT kupp$proc.default_dop

      FROM dual;

      SELECT kupp$proc.default_dop

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object DEFAULT_DOP

DELETE_WORKER_PROCESSES

Undocumented kupp$proc.delete_worker_processes;

exec kupp$proc.delete_worker_processes;

      *

      ERROR at line 1:

      ORA-39110: error deleting worker processes

      ORA-31610: cannot call this function from a non-master process

      ORA-06512: at "SYS.KUPP$PROC", line 102

      ORA-06512: at "SYS.KUPP$PROC", line 383

      ORA-06512: at line 1

DISABLE_MULTIPROCESS

Undocumented kupp$proc.disable_multiprocess RETURN BINARY_INTEGER;

SELECT kupp$proc.disable_multiprocess

      FROM dual;

      

      DISABLE_MULTIPROCESS

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

                   
      1

ENABLE_FLASHBACK_DMLS

Undocumented kupp$proc.enable_flashback_dmls;

exec kupp$proc.enable_flashback_dmls;

      

      PL/SQL procedure successfully completed.

ENABLE_MULTIPROCESS

Undocumented kupp$proc.enable_multiprocess RETURN BINARY_INTEGER;

SELECT kupp$proc.enable_multiprocess

      FROM dual;

      

      ENABLE_MULTIPROCESS

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

                        1

GET_CIT_FLAG (new 21c)

Undocumented kupp$proc.get_cit_flag RETURN BINARY_INTEGER;

SELECT kupp$proc.get_cit_flag

      FROM dual;

      

      GET_CIT_FLAG

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

                 0

GET_NLS_ALTER_SESSION

Undocumented kupp$proc.get_nls_alter_session RETURN VARCHAR2;

SELECT kupp$proc.get_nls_alter_session

      FROM dual;

      

      GET_NLS_ALTER_SESSION

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

GET_TRACE_DEBUG

Undocumented kupp$proc.get_trace_debug RETURN BINARY_INTEGER;

SELECT kupp$proc.get_trace_debug

      FROM dual;

      

      GET_TRACE_DEBUG

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

                    0

GET_WORKER_EXCEPTION

Undocumented kupp$proc.get_worker_exception( worker_id OUT BINARY_INTEGER, worker_name OUT VARCHAR2, worker_name_size IN BINARY_INTEGER, error_code OUT BINARY_INTEGER, error_stack OUT VARCHAR2, error_stack_size IN BINARY_INTEGER);

TBD

INIT_DONE

Undocumented kupp$proc.init_done;

exec kupp$proc.init_done;

      

      PL/SQL procedure successfully completed.

IS_MULTIPROCESS_ENABLED

Returns a 1 if multiprocess is enable, otherwise 0

See ENABLE_MULTIPROCESS and DISABLE_MULTIPROCESS on this page kupp$proc.is_multiprocess_enabled RETURN BINARY_INTEGER;

SELECT 
      kupp$proc.is_multiprocess_enabled

      FROM dual;

      

      IS_MULTIPROCESS_ENABLED

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

                      
      1

JOB_ALIVE

Undocumented kupp$proc.job_alive(jobser IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

KILL_WORKER

Deletes the identified worker process kupp$proc.kill_worker(worker_id IN BINARY_INTEGER);

 exec kupp$proc.kill_worker(1);

      BEGIN kupp$proc.kill_worker(1); END;

      

      *

      ERROR at line 1:

      ORA-39110: error deleting worker processes

      ORA-31610: cannot call this function from a non-master process

      ORA-06512: at "SYS.KUPP$PROC", line 968

      ORA-06512: at line 1

MAX_DOP (new 21c)

Undocumented

Protected by an ACCESSIBLE BY clause kupp$proc.max_dop(curr_max IN BINARY_INTEGER) RETURN BINARY_INTEGER;

SELECT kupp$proc.max_dop(4)

      FROM dual;

      SELECT kupp$proc.max_dop(4)

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object MAX_DOP

OPTION_ENABLED

Undocumented

The only value that returns TRUE in my tests is one (1) kupp$proc.option_enabled(optval IN BINARY_INTEGER) RETURN BOOLEAN;

set serveroutput on

      

      BEGIN

        IF kupp$proc.option_enabled(-1) THEN

          dbms_output.put_line('-1');

         END IF;

      END;

      /

      *

      ERROR at line 1:

      ORA-01426: numeric overflow

      ORA-06512: at "SYS.KUPP$PROC", line 944

      ORA-06512: at "SYS.KUPP$PROC", line 959

      ORA-06512: at line 2

      

      BEGIN

        2    IF kupp$proc.option_enabled(0) THEN

        3       dbms_output.put_line('0');

        4    END IF;

      END;

      /

      

      PL/SQL procedure successfully completed.

      

      BEGIN

        2    IF kupp$proc.option_enabled(1) THEN

        3      dbms_output.put_line('1');

        4    END IF;

      END;

      /

      1

      

      PL/SQL procedure successfully completed.

      

      BEGIN

         IF kupp$proc.option_enabled(999999999) THEN

          dbms_output.put_line('999999999');

        END IF;

      END;

      /

      

      PL/SQL procedure successfully completed.

      

      BEGIN

         IF kupp$proc.option_enabled(9999999999) THEN

          dbms_output.put_line('9999999999');

         END IF;

      END;

      /

      *

      ERROR at line 1:

      ORA-01426: numeric overflow

      ORA-06512: at line 2

SEC_TT_LOADED

Undocumented kupp$proc.sec_tt_loaded;

exec kupp$proc.sec_tt_loaded;

      BEGIN kupp$proc.sec_tt_loaded; END;

      *

      ERROR at line 1:

      ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [], [], [], [], []

      ORA-31610: cannot call this function from a non-master process

      ORA-06512: at "SYS.KUPP$PROC", line 977

      ORA-06512: at line 1

SEC_TT_UNLOADED

Undocumented kupp$proc.sec_tt_unloaded;

exec kupp$proc.sec_tt_unloaded;

      BEGIN kupp$proc.sec_tt_unloaded; END;

      *

      ERROR at line 1:

      ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [], [], [], [], []

      ORA-31610: cannot call this function from a non-master process

      ORA-06512: at "SYS.KUPP$PROC", line 985

      ORA-06512: at line 1

SET_CIT_FLAG (new 21c)

Undocumented

Protected by an ACCESSIBLE BY clause kupp$proc.set_cit_flag(newval IN BINARY_INTEGER);

exec 
      kupp$proc.set_cit_flag(1);

      BEGIN kupp$proc.set_cit_flag(1); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object SET_CIT_FLAG

SET_PROFILING

Undocumented kupp$proc.set_profiling(on_flag IN BOOLEAN);

exec kupp$proc.set_profiling(FALSE);

      

      PL/SQL procedure successfully completed.

SET_REMOTE_WORKER

Undocumented kupp$proc.set_remote_worker(worker_id IN NUMBER);

exec 
      kupp$proc.set_remote_worker(9);

      

      PL/SQL procedure successfully completed.

SET_TRACE_DEBUG

Undocumented kupp$proc.set_trace_debug( debug_flags IN BINARY_INTEGER, caller_type IN BINARY_INTEGER, remote_op IN BOOLEAN);

TBD

SHUTDOWN_IN_PROGRESS

Returns TRUE if the container is in the process of shutting down kupp$proc.shutdown_in_progress RETURN BOOLEAN;

BEGIN

        IF kupp$proc.shutdown_in_progress THEN

          dbms_output.put_line('Shutdown In Progress');

        ELSE

          dbms_output.put_line('Shutdown Is Not In Progress');

        END IF;

      END;

      /

      Shutdown Is Not In Progress

      

      PL/SQL procedure successfully completed.

TOTAL_WORKERS_ALIVE

Undocumented kupp$proc.total_workers_alive(worker_exceptions_queued OUT BINARY_INTEGER) RETURN BINARY_INTEGER;

DECLARE

       ret PLS_INTEGER;

       weq PLS_INTEGER;

      BEGIN

        ret := kupp$proc.total_workers_alive(weq);

        dbms_output.put_line(ret);

        dbms_output.put_line(weq);

      END;

      /

      *

      ERROR at line 1:

      ORA-39003: unable to get count of total workers alive

      ORA-31610: cannot call this function from a non-master process

      ORA-06512: at "SYS.KUPP$PROC", line 883

      ORA-06512: at line 5

WHATS_MY_ID

Returns the current user's user_id from USER$ kupp$proc.whats_my_id RETURN BINARY_INTEGER;

sho user

      USER is "SYS"

      

      SELECT user_id

      FROM dba_users

      WHERE username = 'SYS';

      

         USER_ID

      ----------

               0

      

      SELECT kupp$proc.whats_my_id

      FROM dual;

      

      WHATS_MY_ID

      -----------

                0

WHATS_MY_NAME

Outputs the name of a Data Pump process based on process name size kupp$proc.whats_my_name( process_name OUT VARCHAR2, process_name_size IN BINARY_INTEGER);

DECLARE

       outVal VARCHAR2(30);

      BEGIN

        kupp$proc.whats_my_name(outVal, 14);

  dbms_output.put_line(outVal);

      END;

      /

      *

      ERROR at line 1:

      ORA-39160: error on whats my name call

      ORA-39159: cannot call this function from a non-Data Pump process

      ORA-06512: at "SYS.KUPP$PROC", line 228

      ORA-06512: at "SYS.KUPP$PROC", line 1095

      ORA-06512: at line 4

WHAT_AM_I

Undocumented but seems to always return zero (0) kupp$proc.what_am_id RETURN BINARY_INTEGER;

SELECT kupp$proc.what_am_i

      FROM dual;

      

       WHAT_AM_I

      ----------

         0

WHAT_ORACLE_PRODUCT

Undocumented: Oracle Enterprise Edition version 11.2.0.3 and 12.1.0.2 both return 8 kupp$proc.what_oracle_product RETURN BINARY_INTEGER;

SELECT kupp$proc.what_oracle_product

      FROM dual;

      

      WHAT_ORACLE_PRODUCT

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

                  
      8

WORKER_EXTTBL_ACTIVE

Undocumented kupp$proc.worker_exttbl_active;

exec kupp$proc.worker_exttbl_active;

      *

      ERROR at line 1:

      ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [], [], [], [], []

      ORA-39159: cannot call this function from a non-Data Pump process

      ORA-06512: at "SYS.KUPP$PROC", line 1001

      ORA-06512: at line 1

WORKER_EXTTBL_FULLNAME

Undocumented kupp$proc.worker_exttbl_fullName( exttbl_schema IN VARCHAR2, exttbl_name IN VARCHAR2);

exec kupp$proc.worker_exttbl_fullName('C##SH', 'SALES');

      *

      ERROR at line 1:

      ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [], [], [], [], []

      ORA-39159: cannot call this function from a non-Data Pump process

      ORA-06512: at "SYS.KUPP$PROC", line 990

      ORA-06512: at line 1

WORKER_EXTTBL_INACTIVE

Undocumented kupp$proc.worker_exttbl_inactive(

exec kupp$proc.worker_exttbl_inactive;

      *

      ERROR at line 1:

      ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [], [], [], [], []

      ORA-39159: cannot call this function from a non-Data Pump process

      ORA-06512: at "SYS.KUPP$PROC", line 1001

      ORA-06512: at line 1

WORKER_PROCESS_INIT

Undocumented kupp$proc.worker_process_init( max_workers IN BINARY_INTEGER, use_cluster IN BINARY_INTEGER, svcname IN VARCHAR2);

TBD

WORKER_SERVICE_INIT

Undocumented kupp$proc.worker_service_init(svcnam IN VARCHAR2);

SELECT DISTINCT name

      FROM v$active_services;

      

      exec kupp$proc.worker_service_init('SYS$USERS');

      BEGIN kupp$proc.worker_service_init('SYS$USERS'); 
      END;

      *

      ERROR at line 1:

      ORA-31686: error creating worker processes

      ORA-39159: cannot call this function from a non-Data Pump process

      ORA-06512: at "SYS.KUPP$PROC", line 209

      ORA-06512: at "SYS.KUPP$PROC", line 356

      ORA-06512: at line 1