Oracle KUPC$QUE_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
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 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx