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