Oracle | KUPC$QUE

Oracle KUPC$QUE_INT 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 DEFINER

Dependencies

AQ$_AGENT	DBMS_ASSERT	KUPC$QUEUE_INT
DBA_DATA_FILES	DBMS_LOCK	KUPC$_MESSAGE
DBA_FREE_SPACE	DBMS_RANDOM	KUPCC
DBA_QUEUES	DBMS_SYS_ERROR	KUPF$FILE
DBA_QUEUE_TABLES	DBMS_UTILITY	KUPP$PROC
DBA_TABLESPACES	GV_$DATAPUMP_JOB	KUPUTIL
DBMS_AQ	GV_$PX_SESSION	KUPV$FT_INT
DBMS_AQADM	KUPC$QUEUE	PLITBLM
DBMS_AQADM_SYS

Documented No

Exceptions

Error Code	Reason
`ORA-39078`	`Unable to dequeue message for agent from queue ""`
`ORA-39097`	`Data Pump job encountered unexpected error -942`

First Available Not known

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

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

Subprograms

ATTACH_QUEUE	DETACH_QUEUES	PUT_STATUS
ATTACH_QUEUES	GET_STATUS	RECEIVE
CREATE_QUEUES	GET_STATUS_MSG_COUNT	SEND
DELETE_QUEUES	GET_SUBSCRIBER_COUNT	SET_DEBUG
DETACH_QUEUE	PREPARE_QUEUE_TABLE	TRANSCEIVE_INT

ATTACH_QUEUE

Undocumented kupc$que_int.attach_queue( ob_name IN VARCHAR2, job_owner IN VARCHAR2, caller_type IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

ATTACH_QUEUES

Undocumented kupc$que_int.attach_queues(job_handle IN NUMBER) RETURN VARCHAR2;

TBD

CREATE_QUEUES

Undocumented kupc$que_int.create_queues( job_name IN VARCHAR2, job_owner IN VARCHAR2, que_tabnum IN BINARY_INTEGER, control_queue OUT VARCHAR2, status_queue OUT VARCHAR2);

TBD

DELETE_QUEUES

Undocumented kupc$que_int.delete_queues( control_queue IN VARCHAR2, status_queue IN VARCHAR2);

TBD

DETACH_QUEUE

Undocumented kupc$que_int.detach_queue;

exec kupc$que_int.detach_queue;

      

      PL/SQL procedure successfully completed.

DETACH_QUEUES

Undocumented kupc$que_int.detach_queues(job_handle IN NUMBER);

TBD

GET_STATUS

Undocumented kupc$que_int.get_status( job_handle IN NUMBER, timeout IN NUMBER) RETURN sys.kupc$_message;

TBD

GET_STATUS_MSG_COUNT

Undocumented kupc$que_int.get_status_msg_count RETURN NUMBER;

DECLARE

       retVal NUMBER;

      BEGIN

        retVal := kupc$que_int.get_status_msg_count;

        dbms_output.put_line(retVal);

      END;

      /

      *

      ORA-39097: Data Pump job encountered unexpected error -942

GET_SUBSCRIBER_COUNT

Undocumented kupc$que_int.get_subscriber_count RETURN NUMBER;

DECLARE

       retVal NUMBER;

      BEGIN

        retVal := kupc$que_int.get_subscriber_count;

        dbms_output.put_line(retVal);

      END;

      /

      *

      ORA-39097: Data Pump job encountered unexpected error -942

PREPARE_QUEUE_TABLE

Undocumented kupc$que_int.prepare_queue_table RETURN BINARY_INTEGER;

DECLARE

       retVal BINARY_INTEGER;

      BEGIN

        retVal := kupc$que_int.prepare_queue_table;

        dbms_output.put_line(retVal);

      END;

      /

       retVal := kupc$que_int.prepare_queue_table;

                              *

      PLS-00904: insufficient privilege to access object PREPARE_QUEUE_TABLE

PUT_STATUS

Undocumented kupc$que_int.put_status( status IN sys.kupc$_message, recipient IN VARCHAR2, priority IN NUMBER);

TBD

RECEIVE

Undocumented kupc$que_int.receive(timeout IN NUMBER) RETURN sys.kupc$_message;

DECLARE

       retVal sys.kupc$_message;

      BEGIN

        retVal := kupc$que_int.receive(1);

      END;

      /

      *

      ORA-39078: unable to dequeue message for agent from queue ""

SEND

Undocumented

Overload 1 kupc$que_int.send( message IN sys.kupc$_message, recipient IN VARCHAR2, priority IN NUMBER);

TBD

Overload 2 kupc$que_int.send( message IN sys.kupc$_message, orig_request IN sys.kupc$_message, priority IN NUMBER);

TBD

SET_DEBUG

Undocumented kupc$que_int.set_debug(debug_flags IN BINARY_INTEGER);

exec kupc$que_int.set_debug(1);

           *

      PLS-00904: insufficient privilege to access object SET_DEBUG

TRANSCEIVE_INT

Undocumented kupc$que_int.tranceive_int( message IN sys.kupc$_message, job_handle IN NUMBER, timeout IN NUMBER, priority IN NUMBER, recipient IN VARCHAR2) RETURN sys.kupc$_message;

TBD