Oracle | KUPC$QUEUE

Oracle KUPC$QUEUE_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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