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 will be available on generic Linux platforms in January and soon on AIX and Windows

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