Oracle DBMS_AQADM_SYSCALLS
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose Advanced Queuing Administrative APIs.
AUTHID DEFINER
Dependencies
AQ$_AGENT DBMS_AQ_LIB
AQ$_BND DBMS_AQ_SYS_EXP_INTERNAL
AQ$_BND_ARRAY DBMS_AQ_SYS_IMP_INTERNAL
AQ$_QUEUES DBMS_ASSERT
AQ$_QUEUE_TABLES DBMS_PRVTAQIM
DBMS_AQ DBMS_PRVTAQIP
DBMS_AQADM DBMS_PRVTAQIS
DBMS_AQADM_INV DBMS_PRVTSQDS
DBMS_AQADM_LIB DBMS_PRVTSQIS
DBMS_AQADM_SYS DBMS_RULEADM_INTERNAL
DBMS_AQADM_VAR DBMS_RULE_ADM
DBMS_AQINT_LIB DBMS_RULE_IMP_OJ
DBMS_AQJMS DBMS_STREAMS_CONTROL_ADM
DBMS_AQMIGTOOL DBMS_SYS_ERROR
DBMS_AQMIGTOOL_SYS DBMS_TEQK
DBMS_AQ_IMPORT_INTERNAL RE$NAME_ARRAY
DBMS_AQ_IMPORT_INTERNAL_DR  
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
{ORACLE_HOME}/rdbms/admin/prvtaqdi.plb
Subprograms
EXECUTE_STMT_IN_KERNEL_CURSOR KWQA_3GL_ISDICTPROTECTED
GET_MAX_STREAMS_POOL KWQA_3GL_ISSTREAMSCAPTUREOFF
GET_MIN_STREAMS_POOL KWQA_3GL_ISTTSIMPORT
GET_OWNER_INSTANCE KWQA_3GL_KWQAADDQMONJIT
GET_WATERMARK KWQA_3GL_KWQAADDTEQJIT
IS_AQ_APPLY KWQA_3GL_KWQAORDDRPITAB
IS_LOGICAL_STBY KWQA_3GL_LOCKQUEUE
IS_OGG_DEST KWQA_3GL_LOCKQUEUETABLE
IS_OGG_REPL KWQA_3GL_MARK_INTERNAL_TABLES
IS_OGG_SRC KWQA_3GL_NFYNOI
IS_PRIMARY KWQA_3GL_NTFNTRCCHK
IS_QUEUE_REPLICATED KWQA_3GL_PARSEAQNAME
IS_RU_SWITCH KWQA_3GL_PRINTREMSUBLIST
KWQA_3GL_ADDSUBSCRIBER KWQA_3GL_PURGEREMSUBLIST
KWQA_3GL_ALTERCACHEOBJECT KWQA_3GL_PURGE_CBK_OBJ
KWQA_3GL_ALTERQUEUE KWQA_3GL_PURGE_QUEUE_TABLE
KWQA_3GL_ALTERSUBSCRIBER KWQA_3GL_QT_COMPAT
KWQA_3GL_ANALYZE_MSG_CACHE KWQA_3GL_REMOVESUBSCRIBER
KWQA_3GL_AQPKG KWQA_3GL_REVOKE
KWQA_3GL_AQ_INT_DDL KWQA_3GL_SCHEDULETMSERVICE
KWQA_3GL_BEGINTRANS KWQA_3GL_SETMSGWAIT
KWQA_3GL_CALCULATE_MSG_CACHE KWQA_3GL_SETREGISTRATIONNAME
KWQA_3GL_CHANGE_REP_MOD KWQA_3GL_SETSTREAMSCAPTUREOFF
KWQA_3GL_CREATEADTPLODINFO KWQA_3GL_SET_CLR_TABLE_FLAG
KWQA_3GL_CREATECACHEOBJECT KWQA_3GL_SET_PARAMS_IN_QKGL
KWQA_3GL_CREATEQUEUE KWQA_3GL_SET_TABLE_STATS_LOCK
KWQA_3GL_CREATEQUEUE_12G KWQA_3GL_SET_VIEW_FLAG
KWQA_3GL_DESTROYCACHEOBJECT KWQA_3GL_STARTQUEUE
KWQA_3GL_DMPESTACK KWQA_3GL_STOPQUEUE
KWQA_3GL_DROPQUEUE KWQA_3GL_STOP_MSG_FORWARDING
KWQA_3GL_DROPREGISTRATIONS KWQA_3GL_UNSET_PARAMS_IN_QKGL
KWQA_3GL_ENDTRANS KWQA_3GL_UPDKGQM
KWQA_3GL_EVENTLEVEL KWQA_3GL_VALIDATEQUEUE
KWQA_3GL_EXECUTESTMT KWQA_GET_UNDERSCORE_PARAMS
KWQA_3GL_FIND_DATE SET_MAX_STREAMS_POOL
KWQA_3GL_GET_PARAMS_IN_QKGL SET_MIN_STREAMS_POOL
KWQA_3GL_GRANT SET_WATERMARK
KWQA_3GL_INVALIDATEQUEUE UPDATE_RETRY
 
EXECUTE_STMT_IN_KERNEL_CURSOR
Undocumented dbms_aqadm_syscalls.execute_stmt_in_kernel_cursor(
sql_stmt   IN VARCHAR2,
ignore_ddl IN BOOLEAN);
TBD
 
GET_MAX_STREAMS_POOL
Undocumented

All package functionality is protected by an ACCESSIBLE BY Clause
dbms_aqadm_syscalls.get_max_streams_pool(value OUT NUMBER);
DECLARE
 n NUMBER;
BEGIN
  dbms_aqadm_syscalls.get_max_streams_pool(n);
  dbms_output.put_line(n);
END;
/
*
ORA-06550: line 4, column 3:
PLS-00904: insufficient privilege to access object DBMS_AQADM_SYSCALLS
 
GET_MIN_STREAMS_POOL
Undocumented dbms_aqadm_syscalls.get_min_streams_pool(value OUT NUMBER);
TBD
 
GET_OWNER_INSTANCE
Undocumented dbms_aqadm_syscalls.get_owner_instance(
primary_instance    IN BINARY_INTEGER,
secondary_instance  IN BINARY_INTEGER,
curr_owner_instance IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
GET_WATERMARK
Undocumented dbms_aqadm_syscalls.get_watermark(wmvalue OUT NUMBER);
TBD
 
IS_AQ_APPLY (new 23ai)
Undocumented dbms_aqadm_syscalls.is_aq_apply RETURN BOOLEAN;
TBD
 
IS_LOGICAL_STBY
Undocumented dbms_aqadm_syscalls.is_logical_stby RETURN BOOLEAN;
TBD
 
IS_OGG_DEST
Undocumented dbms_aqadm_syscalls.is_ogg_dest RETURN BOOLEAN;
TBD
 
IS_OGG_REPL (new 23ai)
Undocumented dbms_aqadm_syscalls.is_ogg_repl BOOLEAN;
TBD
 
IS_OGG_SRC
Undocumented dbms_aqadm_syscalls.is_ogg_src RETURN BOOLEAN;
TBD
 
IS_PRIMARY
Undocumented dbms_aqadm_syscalls.is_primary RETURN BOOLEAN;
TBD
 
IS_QUEUE_REPLICATED
Undocumented dbms_aqadm_syscalls.is_queue_replicated(
name_type        IN  BINARY_INTEGER,
qt_name          IN  VARCHAR2,
queue_name       IN VARCHAR2,
crt_flag         IN  BOOLEAN,
ext_flag         IN  BOOLEAN,
replication_mode IN  BINARY_INTEGER,
can_obj_name     OUT VARCHAR2,
can_obj_sch      OUT VARCHAR2,
iqrepl           OUT BOOLEAN,
current_user     IN  VARCHAR2);
TBD
 
IS_RU_SWITCH (new 23ai)
Undocumented dbms_aqadm_syscalls.is_ru_switch BOOLEAN;
TBD
 
KWQA_3GL_ADDSUBSCRIBER
Undocumented dbms_aqadm_syscalls.kwqa_3gl_addsubscriber(
q_schema      IN  VARCHAR2,
q_name        IN  VARCHAR2,
sub           IN  sys.aq$_agent,
sub_type      IN  NUMBER,
rule          IN  VARCHAR2,
trans_owner   IN  VARCHAR2,
trans_name    IN  VARCHAR2,
ruleset_owner IN  VARCHAR2,
ruleset_name  IN  VARCHAR2,
negrset_owner IN  VARCHAR2,
negrset_name  IN  VARCHAR2,
sub_id        IN  NUMBER,
proxy_id      IN  NUMBER,
proxy_addr    IN  VARCHAR2,
addr_id       IN  NUMBER,
creation_time IN  TIMESTAMP WITH TIME ZONE,
scn_at_add    OUT NUMBER);
TBD
 
KWQA_3GL_ALTERCACHEOBJECT
Undocumented dbms_aqadm_syscalls.kwqa_3gl_altercacheobject(
jobname  IN VARCHAR2,
duration IN NUMBER,
latency  IN NUMBER);
TBD
 
KWQA_3GL_ALTERQUEUE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_alterqueue(
owner          IN VARCHAR2,
queue_name     IN VARCHAR2,
max_retry      IN BINARY_INTEGER,
retry_interval IN BINARY_INTEGER,
retention      IN BINARY_INTEGER,
comment        IN VARCHAR2,
flow_control   IN BINARY_INTEGER,
rep_queue      IN BINARY_INTEGER);
TBD
 
KWQA_3GL_ALTERSUBSCRIBER
Undocumented dbms_aqadm_syscalls.kwqa_3gl_altersubscriber(
q_schema          IN VARCHAR2,
q_name            IN VARCHAR2,
sub               IN sys.aq$agent,
new_rule_name     IN VARCHAR2,
ex_rule_name      IN VARCHAR2,
new_trans_name    IN VARCHAR2,
full_ruleset      IN VARCHAR2,
ex_ruleset        IN VARCHAR2,
full_negrset      IN VARCHAR2,
ex_negrset        IN VARCHAR2,
modification_time IN TIMESTAMP WITH TIME ZONE,
current_user      IN VARCHAR2)
TBD
 
KWQA_3GL_ANALYZE_MSG_CACHE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_analyze_msg_cache(
inst_id    IN BINARY_INTEGER,
schema     IN VARCHAR2,
qname      IN VARCHAR2,
queue_id   IN BINARY_INTEGER,
pdb        IN BINARY_INTEGER,
input_flag IN BINARY_INTEGER);
TBD
 
KWQA_3GL_AQPKG
Undocumented dbms_aqadm_syscalls.kwqa_3gl_aqpkg RETURN BOOLEAN;
TBD
 
KWQA_3GL_AQ_INT_DDL (new 23ai)
Undocumented dbms_aqadm_syscalls.kwqa_aq_int_ddl RETURN BOOLEAN;
TBD
 
KWQA_3GL_BEGINTRANS
Undocumented dbms_aqadm_syscalls.kwqa_3gl_begintrans(
set_nocmt IN  BOOLEAN,
old_state OUT BOOLEAN);
TBD
 
KWQA_3GL_CALCULATE_MSG_CACHE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_calculate_msg_cache(inst_id IN BINARY_INTEGER);
TBD
 
KWQA_3GL_CHANGE_REP_MOD
Undocumented dbms_aqadm_syscalls.kwqa_3gl_change_rep_mod(
schema  IN VARCHAR2,
qname   IN VARCHAR2,
qt_flag IN BINARY_INTEGER);
TBD
 
KWQA_3GL_CREATEADTPLODINFO
Undocumented dbms_aqadm_syscalls.kwqa_3gl_createadtplodinfo(
owner      IN VARCHAR2,
queue_name IN VARCHAR2,
adt_schema IN VARCHAR2,
adt_name   IN VARCHAR2,
qt_flags   IN BINARY_INTEGER);
TBD
 
KWQA_3GL_CREATECACHEOBJECT
Undocumented dbms_aqadm_syscalls.kwqa_3gl_createcacheobject(
destination IN VARCHAR2,
jobname     IN VARCHAR2,
duration    IN NUMBER,
myoid       IN RAW,
latency     IN NUMBER,
destq       IN BINARY_INTEGER);
TBD
 
KWQA_3GL_CREATEQUEUE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_createqueue(
owner          IN VARCHAR2,
queue_name     IN VARCHAR2,
table_name     IN VARCHAR2,
compatible     IN BINARY_INTEGER,
queue_oid      IN RAW,
queue_type     IN BINARY_INTEGER,
max_retry      IN BINARY_INTEGER,
retry_interval IN BINARY_INTEGER,
tracking       IN BOOLEAN,
retention      IN BINARY_INTEGER,
owner_instance IN BINARY_INTEGER,
comment        IN VARCHAR2,
qt_flags       IN BINARY_INTEGER,
sort_order     IN BINARY_INTEGER,
timezone       IN VARCHAR2,
create_import  IN BOOLEAN,
shard_count    IN BINARY_INTEGER);
TBD
 
KWQA_3GL_CREATEQUEUE_12G
Undocumented dbms_aqadm_syscalls.kwqa_3gl_createqueue_12g(
owner          IN VARCHAR2,
queue_name     IN VARCHAR2,
table_name     IN VARCHAR2,
compatible     IN BINARY_INTEGER,
queue_oid      IN RAW,
queue_type     IN BINARY_INTEGER,
max_retry      IN BINARY_INTEGER,
retry_interval IN BINARY_INTEGER,
tracking       IN BOOLEAN,
retention      IN BINARY_INTEGER,
owner_instance IN BINARY_INTEGER,
comment        IN VARCHAR2,
qt_flags       IN BINARY_INTEGER,
timezone       IN VARCHAR2,
create_import  IN BOOLEAN);
TBD
 
KWQA_3GL_DESTROYCACHEOBJECT
Undocumented dbms_aqadm_syscalls.kwqa_3gl_destroycacheobject(
jobname IN VARCHAR2,
dest    IN VARCHAR2,
myoid   IN RAW);
TBD
 
KWQA_3GL_DMPESTACK
Undocumented dbms_aqadm_syscalls.kwqa_3gl_dmpestack;
TBD
 
KWQA_3GL_DROPQUEUE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_dropqueue(
owner      IN VARCHAR2,
queue_name IN VARCHAR2,
force      IN BOOLEAN);
TBD
 
KWQA_3GL_DROPREGISTRATIONS
Undocumented dbms_aqadm_syscalls.kwqa_3gl_dropregistrations(
schema IN VARCHAR2,
qname  IN VARCHAR2)
TBD
 
KWQA_3GL_ENDTRANS
Undocumented dbms_aqadm_syscalls.kwqa_3gl_endtrans(
commit_trans IN BOOLEAN,
old_state    IN BOOLEAN)
TBD
 
KWQA_3GL_EVENTLEVEL
Undocumented dbms_aqadm_syscalls.kwqa_3gl_eventlevel(event IN BINARY_INTEGER) RETURN BINARY_INTEGER;
TBD
 
KWQA_3GL_EXECUTESTMT
Undocumented dbms_aqadm_syscalls.kwqa_3gl_executestmt(stmt IN VARCHAR2);
TBD
 
KWQA_3GL_FIND_DATE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_find_date(
interval     IN  VARCHAR2,
next_date    OUT DATE,
current_user IN  VARCHAR2);
TBD
 
KWQA_3GL_GET_PARAMS_IN_QKGL
Undocumented dbms_aqadm_syscalls.kwqa_3gl_get_params_in_qkgl(
queue_schema IN  VARCHAR2,
queue_name   IN  VARCHAR2,
param_name   IN  VARCHAR2,
param_value  OUT NUMBER);
TBD
 
KWQA_3GL_GRANT
Undocumented dbms_aqadm_syscalls.kwqa_3gl_grant(
owner      IN VARCHAR2,
queue_name IN VARCHAR2,
grantee    IN VARCHAR2,
privilege  IN BINARY_INTEGER,
is_syspriv IN PL/SQL BOOLEAN,
cascade    IN BOOLEAN,
grantor    IN VARCHAR2);
TBD
 
KWQA_3GL_INVALIDATEQUEUE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_invalidatequeue(
qt_schema IN VARCHAR2,
q_name    IN VARCHAR2);
TBD
 
KWQA_3GL_ISDICTPROTECTED (new 23ai)
Undocumented dbms_aqadm_syscalls.kwqa_3gl_isdictprotected(
current_uer  IN  VARCHAR2,
object_owner IN  VARCHAR2,
isprotected  OUT NUMBER);
TBD
 
KWQA_3GL_ISSTREAMSCAPTUREOFF
Undocumented dbms_aqadm_syscalls.kwqa_3gl_isstreamscaptureoff RETURN BOOLEAN;
TBD
 
KWQA_3GL_ISTTSIMPORT
Undocumented dbms_aqadm_syscalls.kwqa_3gl_isttsimport RETURN BOOLEAN;
TBD
 
KWQA_3GL_KWQAADDQMONJIT (new 23ai)
Undocumented dbms_aqadm_syscallskwqa_3gl_kwqaaddqmonjit(
qschema IN VARCHAR2,
qname   IN VARCHAR2);
TBD
 
KWQA_3GL_KWQAADDTEQJIT (new 23ai)
Undocumented dbms_aqadm_syscalls.kwqa_3gl_kwqaaddteqjit(
qschema IN VARCHAR2,
qname   IN VARCHAR2);
TBD
 
KWQA_3GL_KWQAORDDRPITAB (new 23ai)
Undocumented dbms_aqadm_syscalls.kwqa_3gl_kwqaorddrpitab(
owner IN VARCHAR2,
tname IN VARCHAR2);
TBD
 
KWQA_3GL_LOCKQUEUE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_lockqueue(
q_schema      IN VARCHAR2,
q_name        IN VARCHAR2,
operation     IN VARCHAR2,
flags         IN BINARY_INTEGER,
ignore_errors IN BOOLEAN);
TBD
 
KWQA_3GL_LOCKQUEUETABLE
Undocumented

Overload 1
dbms_aqadm_syscalls.kwqa_3gl_lockqueuetable(
qt_schema IN VARCHAR2,
qt_name   IN VARCHAR2,
operation IN VARCHAR2,
flags     IN BINARY_INTEGER);
TBD
Overload 2 dbms_aqadm_syscalls.kwqa_3gl_lockqueuetable(
qt_schema    IN  VARCHAR2,
qt_name      IN  VARCHAR2,
operation    IN  VARCHAR2,
flags        IN  BINARY_INTEGER,
qtab_exists  OUT BOOLEAN,
qtdct_exists OUT BOOLEAN,
qtobjno      OUT NUMBER,
qt_flags     OUT BINARY_INTEGER,
qt_owner     OUT BINARY_INTEGER);
TBD
 
KWQA_3GL_MARK_INTERNAL_TABLES
Undocumented dbms_aqadm_syscalls.kwqa_3gl_mark_internal_tables(set_indictor_flg IN BINARY_INTEGER);
TBD
 
KWQA_3GL_NFYNOI
Undocumented dbms_aqadm_syscalls.kwqa_3gl_nfynoi(
qtobjno IN NUMBER,
instid  IN BINARY_INTEGER);
TBD
 
KWQA_3GL_NTFNTRCCHK
Undocumented dbms_aqadm_syscalls.kwqa_3gl_ntfntrcchk RETURN BOOLEAN;
TBD
 
KWQA_3GL_PARSEAQNAME
Undocumented dbms_aqadm_syscalls.kwqa_3gl_parseaqname(
ntype          IN  BINARY_INTEGER,
fname          IN  VARCHAR2,
default_schema IN  VARCHAR2,
schema         OUT VARCHAR2,
name           OUT VARCHAR2,
dblkdb         OUT VARCHAR2,
dblkdom        OUT VARCHAR2,
dblkconq       OUT VARCHAR2,
ext_flag       IN  BINARY_INTEGER);
TBD
 
KWQA_3GL_PRINTREMSUBLIST
Undocumented dbms_aqadm_syscalls.kwqa_3gl_printremsublist(
owner      IN VARCHAR2,
queue_name IN VARCHAR2);
TBD
 
KWQA_3GL_PURGEREMSUBLIST
Undocumented dbms_aqadm_syscalls.kwqa_3gl_purgeremsublist(
owner       IN  VARCHAR2,
queue_name  IN  VARCHAR2,
sub         IN  sys.aq$agent,
subid       IN  NUMBER,
ifcheck     IN  BOOLEAN,
pendingtxnx OUT BOOLEAN);
TBD
 
KWQA_3GL_PURGE_CBK_OBJ
Undocumented dbms_aqadm_syscalls.kwqa_3gl_purge_cbk_obj(
schema          IN VARCHAR2,
name            IN VARCHAR2,
qt_flags        IN BINARY_INTEGER,
tobjno          IN NUMBER,
qt_sort_cols    IN BINARY_INTEGER,
delivery_mode   IN BINARY_INTEGER,
purge_condition IN VARCHAR2);
TBD
 
KWQA_3GL_PURGE_QUEUE_TABLE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_purge_queue_table(
schema          IN VARCHAR2,
name            IN VARCHAR2,
qt_flags        IN BINARY_INTEGER,
tobjno          IN NUMBER,
qt_sort_cols    IN BINARY_INTEGER,
delivery_mode   IN BINARY_INTEGER,
purge_condition IN VARCHAR2,
current_user    IN VARCHAR2,
jms             IN BOOLEAN);
TBD
 
KWQA_3GL_QT_COMPAT
Undocumented dbms_aqadm_syscalls.kwqa_3gl_qt_compat(compatible IN VARCHAR2) RETURN BINARY_INTEGER;
TBD
 
KWQA_3GL_REMOVESUBSCRIBER
Undocumented dbms_aqadm_syscalls.kwqa_3gl_removesubscriber(
q_schema IN VARCHAR2,
q_name IN VARCHAR2,
sub IN OBJECT, SYS AQ$_AGENT
rule_name IN VARCHAR2,
ruleset IN VARCHAR2,
negrset IN VARCHAR2,
subid IN NUMBER,
proxyid IN NUMBER,
deletion_time IN TIMESTAMP WITH TIME ZONE,
scn_at_remove OUT NUMBER,
current_user IN VARCHAR2);
TBD
 
KWQA_3GL_REVOKE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_revoke(
owner      IN VARCHAR2,
queue_name IN VARCHAR2,
grantee    IN VARCHAR2,
privilege  IN BINARY_INTEGER,
is_syspriv IN BOOLEAN,
grantor    IN VARCHAR2);
TBD
 
KWQA_3GL_SCHEDULETMSERVICE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_scheduletmservice(
qt_objn        IN NUMBER,
owner_instance IN BINARY_INTEGER);
TBD
 
KWQA_3GL_SETMSGWAIT
Undocumented dbms_aqadm_syscalls.kwqa_3gl_setmsgwait(procname IN VARCHAR2);
TBD
 
KWQA_3GL_SETREGISTRATIONNAME
Undocumented dbms_aqadm_syscalls.kwqa_3gl_setregistrationname(
regname OUT VARCHAR2,
qschema IN  VARCHAR2,
qname   IN  VARCHAR2,
dest    IN  VARCHAR2,
delim   IN  VARCHAR2,
destq   IN  BINARY_INTEGER);
TBD
 
KWQA_3GL_SETSTREAMSCAPTUREOFF
Undocumented dbms_aqadm_syscalls.kwqa_3gl_setstreamscaptureoff(capture_off IN BOOLEAN);
TBD
 
KWQA_3GL_SET_CLR_TABLE_FLAG
Undocumented dbms_aqadm_syscalls.kwqa_3gl_set_clr_table_flag(
qt_schema IN VARCHAR2,
qt_name   IN VARCHAR2,
flag      IN BINARY_INTEGER);
TBD
 
KWQA_3GL_SET_PARAMS_IN_QKGL
Undocumented dbms_aqadm_syscalls.kwqa_3gl_set_params_in_qkgl(
queue_schema IN VARCHAR2,
queue_name   IN VARCHAR2,
param_name   IN VARCHAR2,
param_value  IN NUMBER);
TBD
 
KWQA_3GL_SET_TABLE_STATS_LOCK
Undocumented dbms_aqadm_syscalls.kwqa_3gl_set_table_stats_lock(
ownname    IN VARCHAR2,
objname    IN VARCHAR2,
objsubname IN VARCHAR2,
dslckmode  IN BINARY_INTEGER,
cslckmode  IN BINARY_INTEGER);
TBD
 
KWQA_3GL_SET_VIEW_FLAG
Undocumented dbms_aqadm_syscalls.kwqa_3gl_set_view_flag(
view_schema IN VARCHAR2,
view_name   IN VARCHAR2);
TBD
 
KWQA_3GL_STARTQUEUE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_startqueue(
owner      IN VARCHAR2,
queue_name IN VARCHAR2,
enqueue    IN BOOLEAN,
dequeue    IN BOOLEAN);
TBD
 
KWQA_3GL_STOPQUEUE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_stopqueue(
owner      IN VARCHAR2,
queue_name IN VARCHAR2,
enqueue    IN BOOLEAN,
dequeue    IN BOOLEAN,
wait       IN BOOLEAN);
TBD
 
KWQA_3GL_STOP_MSG_FORWARDING
Undocumented dbms_aqadm_syscalls.kwqa_3gl_stop_msg_forwarding(
schema              IN VARCHAR2,
qname               IN VARCHAR2,
queue_id            IN BINARY_INTEGER,
pdb                 IN BINARY_INTEGER,
shard_id            IN BINARY_INTEGER,
subscriber_id       IN BINARY_INTEGER,
destination_inst_id IN BINARY_INTEGER);
TBD
 
KWQA_3GL_UNSET_PARAMS_IN_QKGL
Undocumented dbms_aqadm_syscalls.kwqa_3gl_unset_params_in_qkgl(
queue_schema IN VARCHAR2,
queue_name   IN VARCHAR2,
param_name   IN VARCHAR2);
TBD
 
KWQA_3GL_UPDKGQM
Undocumented dbms_aqadm_syscalls.kwqa_3gl_updkgqm(
qid          IN NUMBER,
qschema      IN VARCHAR2,
qname        IN VARCHAR2,
flow_control IN BINARY_INTEGER,
op           IN BINARY_INTEGER,
force        IN BOOLEAN);
TBD
 
KWQA_3GL_VALIDATEQUEUE
Undocumented dbms_aqadm_syscalls.kwqa_3gl_validatequeue(
qt_schema IN VARCHAR2,
q_name    IN VARCHAR2);
TBD
 
KWQA_GET_UNDERSCORE_PARAMS (new 23ai)
Undocumented dbms_aqadm_syscalls.kwqa_get_underscore_params(
global_paras IN OUT sys.re$name_array,
qt_flags     IN     BINARY_INTEGER);
desc sys.re$name_array

re$name_Array VARRAY(1024) OF VARCHAR2(128)

DECLARE
 va_up sys.re$name_array;
BEGIN
  dbms_aqadm_syscalls.kwqa_get_underscore_params(va_up, 1);
END;
/
* ERROR at line 4
PLS-00904: insufficient privilege to access object dbms_aqadm_syscalls
 
SET_MAX_STREAMS_POOL
Undocumented dbms_aqadm_syscalls.set_max_streams_pool(value IN NUMBER);
TBD
 
SET_MIN_STREAMS_POOL
Undocumented dbms_aqadm_syscalls.set_min_streams_pool(value IN NUMBER);
TBD
 
SET_WATERMARK
Undocumented dbms_aqadm_syscalls.set_watermark(wmvalue IN NUMBER);
TBD
 
UPDATE_RETRY (new 23ai)
Undocumented dbms_aqadm_syscalls(
q_name        IN VARCHAR2,
consumer_name IN VARCHAR2,
msgid         IN RAW,
deq_opcode    IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
Advanced Queuing Demo 1
Advanced Queuing RAC Demo
DBMS_AQ
DBMS_AQADM_INV
DBMS_AQADM_SYS
DBMS_AQADM_VAR
DBMS_AQIN
DBMS_JOB
DBMS_PRVTAQIP
What's New In 21c
What's New In 26ai

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