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 is now availble. If you haven't you downloaded already: Why?

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