Oracle | KUPC$QUEUE

Oracle KUPC$QUEUE_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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;

      /

      DECLARE

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.KUPC$QUE_INT", line 2089

      ORA-00942: table or view does not exist

      ORA-06512: at "SYS.KUPC$QUE_INT", line 2064

      ORA-06512: at line 1

      ORA-06512: at "SYS.KUPC$QUEUE_INT", line 350

      ORA-06512: at line 4

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;

      /

      DECLARE

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.KUPC$QUE_INT", line 2115

      ORA-00942: table or view does not exist

      ORA-06512: at "SYS.KUPC$QUE_INT", line 2102

      ORA-06512: at line 1

      ORA-06512: at "SYS.KUPC$QUEUE_INT", line 381

      ORA-06512: at line 4

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;

      *

      ERROR at line 4:

      ORA-06550: line 4, column 28:

      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;

      /

      DECLARE

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.KUPC$QUEUE_INT", line 608

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

      ORA-06512: at "SYS.KUPC$QUE_INT", line 710

      ORA-00931: missing identifier

      ORA-06512: at "SYS.DBMS_AQ", line 819

      ORA-06512: at "SYS.KUPC$QUE_INT", line 649

      ORA-06512: at "SYS.KUPC$QUE_INT", line 2279

      ORA-06512: at line 1

      ORA-06512: at "SYS.KUPC$QUEUE_INT", line 597

      ORA-06512: at line 4

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);

      BEGIN kupc$queue_int.set_debug(1); END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      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