Oracle | KUPM$MCP

Oracle KUPM$MCP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose DataPump private internal utilities.

As tempting as it might be to assign this to an AI MCP server this package has existed for a very long time ... definitely prior to any likely Oracle Database AI with MCP server relationship.

AUTHID CURRENT_USER

Data Types desc kupc$_message kupc$_message is NOT FINAL MSGTYPE NUMBER REQUESTID VARCHAR2(128) METHODS ------- MEMBER FUNCTION ISDATAGRAM RETURNS BOOLEAN MEMBER FUNCTION ISREQUEST RETURNS BOOLEAN MEMBER FUNCTION ISRESPONSE RETURNS BOOLEAN

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'KUPM$MCP' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'KUPM$MCP' ORDER BY 1; Returns 100 objects

Documented No

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/prvthpm.plb

Subprograms

CLOSE_JOB	FILE_TO_WORKER	MAINLOOP
DISPATCH	GET_ENDIANNESS	SET_DEBUG
FILE_LOG_MESSAGE	MAIN	VALIDATE_EXPRESSION

CLOSE_JOB

Undocumented
Protected by an ACCESSIBLE BY clause kupm$mcp.close_job;

exec kupm$mcp.close_job;

      

      ORA-00904: insufficient privilege to access object CLOSE_JOB

DISPATCH

Undocumented kupm$mcp.dispatch(request IN sys.kupc$_message) RETURN sys.kupc$_message;

TBD

FILE_LOG_MESSAGE

Undocumented

Overload 1 kupm$mcp.file_log_message(message_text IN VARCHAR2);

exec kupm$mcp.file_log_message('ZZYZX');

      

      PL/SQL procedure successfully completed.

Overload 2 kupm$mcp.file_log_message( errcode IN NUMBER, parameter1 IN VARCHAR2, parameter2 IN VARCHAR2, parameter3 IN VARCHAR2, parameter4 IN VARCHAR2, parameter5 IN VARCHAR2, parameter6 IN VARCHAR2, parameter7 IN VARCHAR2, parameter8 IN VARCHAR2);

TBD

FILE_TO_WORKER

Undocumented kupm$mcp.file_to_worker(message IN sys.kupc$_message);

TBD

GET_ENDIANNESS

Returns the endianness

Now protected with an ACCESSIBLE BY clause kupm$mcp.get_endianness RETURN NUMBER;

SELECT kupm$mcp.get_endianness;

      

      ORA-00904: insufficient privilege to access object CLOSE_JOB

MAIN

Undocumented kupm$mcp.main( job_name IN VARCHAR2, job_owner IN VARCHAR2, restart_job IN BINARY_INTEGER, debug_info IN BINARY_INTEGER, ena_sec_roles IN NUMBER);

TBD

MAINLOOP

Undocumented kupm$mcp.mainloop;

exec kupm$mcp.mainloop;

      

      PL/SQL procedure successfully completed.

SET_DEBUG

Undocumented

Protected by an ACCESSIBLE BY clause kupm$mcp.set_debug(debug_flags IN BINARY_INTEGER);

exec kupm$mcp.set_debug(0);

            *

      PLS-00904: insufficient privilege to access object SET_DEBUG

VALIDATE_EXPRESSION

Undocumented kupm$mcp.validate_expression(expr_value IN VARCHAR2) RETURN NUMBER;

TBD