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

Related Topics
Built-in Functions
Built-in Packages
Database Security
KUPC$QUEUE
KUPC$QUE_INT
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx