Oracle | KUPC$QUE

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

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

      /

      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 4

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;

      /

      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 4

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;

                              *

      ERROR at line 4:

      ORA-06550: line 4, column 26:

      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;

      /

      DECLARE

      *

      ERROR at line 1:

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

      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 4

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

      BEGIN kupc$que_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_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