Oracle | KUPC$QUEUE

Oracle KUPC$QUEUE_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

DBMS_DATAPUMP	KUPCC	KUPP$PROC
KUPC$QUEUE	KUPF$FILE	KUPV$FT_INT
KUPC$QUE_INT	KUPM$MCP	KUPW$WORKER
KUPC$_MESSAGE

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	GET_STATUS	PUT_STATUS
ATTACH_QUEUES	GET_STATUS_MSG_COUNT	RECEIVE
CREATE_QUEUES	GET_SUBSCRIBER_COUNT	SEND
DELETE_QUEUES	ISREMOTE	SET_DEBUG
DETACH_QUEUE	PREPARE_QUEUE_TABLE	TRANSCEIVE
DETACH_QUEUES

ATTACH_QUEUE

Undocumented kupc$queue_int.attach_queue( job_name IN VARCHAR2, job_owner IN VARCHAR2, caller_type IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

ATTACH_QUEUES

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

TBD

CREATE_QUEUES

Undocumented kupc$queue_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$queue_int.delete_queues(

TBD

DETACH_QUEUE

Undocumented kupc$queue_int.detach_queue;

exec kupc$queue_int.detach_queue;

DETACH_QUEUES

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

TBD

GET_STATUS

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

TBD

GET_STATUS_MSG_COUNT

Undocumented kupc$queue_int.get_status_msg_count RETURN NUMBER;

DECLARE

       retVal NUMBER;

      BEGIN

        retVal := kupc$queue_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$queue_int.get_subscriber_count RETURN NUMBER;

DECLARE

       retVal NUMBER;

      BEGIN

        retVal := kupc$queue_int.get_subscriber_count;

        dbms_output.put_line(retVal);

      END;

      /

      *

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

ISREMOTE

Undocumented kupc$queue_int.isRemote(queue IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF kupc$queue_int.isRemote('') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      

      PL/SQL procedure successfully completed.

PREPARE_QUEUE_TABLE

Undocumented kupc$queue_int.prepare_queue_table RETURN BINARY_INTEGER;

DECLARE

       retVal BINARY_INTEGER;

      BEGIN

        retVal := kupc$queue_int.prepare_queue_table;

        dbms_output.put_line(retVal);

      END;

      /

       retVal := kupc$queue_int.prepare_queue_table;

      *

      PLS-00904: insufficient privilege to access object PREPARE_QUEUE_TABLE

PUT_STATUS

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

TBD

RECEIVE

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

DECLARE

       retVal sys.kupc$_message;

      BEGIN

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

      END;

      /

      *

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

SEND

Undocumented

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

TBD

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

TBD

SET_DEBUG

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

exec kupc$queue_int.set_debug(1);

           *

      PLS-00904: insufficient privilege to access object SET_DEBUG

TRANSCEIVE

Undocumented kupc$queue_int.tranceive( message IN OBJECT sys.kupc$_message, job_handle IN NUMBER timeout IN NUMBER priority IN NUMBER recipient IN VARCHAR2) RETURN sys.kupc$_message;

TBD