Oracle | DBMS_AQADM

Oracle DBMS_AQADM_INV 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 Unknown Advanced Queuing Administration

AUTHID CURRENT_USER

Dependencies

DBMS_APPLY_ADM	DBMS_AQMIGTOOL_SYS	DBMS_PRVTAQIS
DBMS_AQ	DBMS_AQ_EXP_QUEUE_TABLES	DBMS_PRVTSQDS
DBMS_AQADM	DBMS_AQINV	DBMS_PRVTSQIS
DBMS_AQADM_LIB	DBMS_AQ_SYS_IMP_INTERNAL	DBMS_RULE_ADM
DBMS_AQADM_SYS	DBMS_ASSERT	DBMS_STREAMS_ADM_UTL
DBMS_AQADM_SYSCALLS	DBMS_LOGREP_UTIL	DBMS_SYSTEM
DBMS_AQADM_VAR	DBMS_PROPAGATION_INTERNAL	DBMS_SYS_ERROR
DBMS_AQINT_LIB	DBMS_PRVTAQIM	DBMS_TEQK
DBMS_AQJMS	DBMS_PRVTAQIP	DBMS_TRANSFORM_EXIMP
DBMS_AQMIGTOOL

Documented No

First Available 18c

Security Model Owned by SYS with no privilege granted

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/dbmsaqds.plb

Subprograms

EXECUTE_STMT	I_PARSE_NAME	KWQA_3GL_CHECKSYSPRIVCUSR
EXECUTE_STMT2	KWQA_3GL_CHECKQUEPRIV	PARSE_NAME
EXECUTE_STMTCUSR	KWQA_3GL_CHECKSYSPRIV	PARSE_SCHEMA
EXECUTE_STMTCUSR2

EXECUTE_STMT

Execute statement dbms_aqadm_inv.execute_stmt( client_stmt IN VARCHAR2, ignore_ddl_dml_error IN BOOLEAN);

DECLARE

       stmt dbms_id := 'CREATE TABLE zzyzx (testcol VARCHAR2(3))';

      BEGIN

        dbms_aqadm_inv(stmt, FALSE);

      END;

      /

      *

      PLS-00904: insufficient privilege to access object DBMS_AQADM_INV

EXECUTE_STMT2

Execute statement dbms_aqadm_inv.execute_stmt2( stmt IN VARCHAR2, ignore_ddl_error IN BOOLEAN, system_cursor IN BOOLEAN, ignore_comperr IN BOOLEAN);

TBD

EXECUTE_STMTCUSR

Execute statement cursor dbms_aqadm_inv.execute_stmtcusr( stmt IN VARCHAR2, current_user IN VARCHAR2, ignore_ddl_dml_error IN BOOLEAN);

TBD

EXECUTE_STMTCUSR2

Execute statement cursor dbms_aqadm_inv.executestmtcusr2( stmt IN VARCHAR2, current_user IN VARCHAR2, ignore_ddl_error IN BOOLEAN, ignore_comperr IN BOOLEAN);

TBD

I_PARSE_NAME

Undocumented dbms_aqadm_inv.i_parse_name( name_type IN BINARY_INTEGER, full_name IN VARCHAR2, default_schema IN VARCHAR2, schema OUT VARCHAR2, name OUT VARCHAR2, dblink_db OUT VARCHAR2, dblink_dom OUT VARCHAR2, dblkconq OUT VARCHAR2, external IN BOOLEAN);

TBD

KWQA_3GL_CHECKQUEPRIV

Check Queue Privileges dbms_aqadm_inv.kwqa_3gl_checkQuePriv( q_schema IN VARCHAR2, q_name IN VARCHAR2, priv IN BINARY_INTEGER, current_user IN VARCHAR2);

TBD

KWQA_3GL_CHECKSYSPRIV

Undocumented

Protected by an ACCESSIBLE BY clause dbms_aqadm_inv.kwqa_3gl_checkSysPriv( obj_schema IN VARCHAR2, syspriv IN BINARY_INTEGER);

exec dbms_aqadm_inv.kwqa_3gl_checkSysPriv('SYS', 1);

           *

      PLS-00904: insufficient privilege to access object DBMS_AQADM_INV

KWQA_3GL_CHECKSYSPRIVCUSR

Undocumented

Protected by an ACCESSIBLE BY clause dbms_aqadm_inv.kwqa_3gl_checkSysPrivCusr( current_user IN VARCHAR2, obj_schema IN VARCHAR2, syspriv IN BINARY_INTEGER);

exec dbms_aqadm_inv.kwqa_3gl_checkSysPrivCusr(USER, 'C##SH', 0);

           *

      PLS-00904: insufficient privilege to access object DBMS_AQADM_INV

PARSE_NAME

Undocumented dbms_aqadm_inv.parse_name( name_type IN BINARY_INTEGER, full_name IN VARCHAR2, schema OUT VARCHAR2, name OUT VARCHAR2, dblink_db OUT VARCHAR2, dblink_dom OUT VARCHAR2, dblkconq OUT VARCHAR2, external IN BOOLEAN, default_schema IN VARCHAR2);

TBD

PARSE_SCHEMA

Undocumented

Protected by an ACCESSIBLE BY clause dbms_aqadm_inv.parse_schema(schema IN VARCHAR2);

exec dbms_aqadm_inv.parse_schema('UWCLASS');

            *

      PLS-00904: insufficient privilege to access object DBMS_AQADM_INV