Oracle | DBMS_AQ_EXP

Oracle DBMS_AQ_EXP_QUEUES 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 Advanced Queuing Export Tables Management

AUTHID CURRENT_USER

Dependencies

DBMS_AQADM_SYS	DBMS_AQ_SYS_EXP_INTERNAL	OBJ$
DBMS_AQ_EXP_ZECURITY	DBMS_AQ_SYS_IMP_INTERNAL	USER$
DBMS_AQ_SYS_EXP_ACTIONS	DBMS_ZHELP_IR

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/

Subprograms

AUDIT_EXP	CREATE_EXP	GRANT_EXP
AUDIT_SYSPRIVS_EXP	DROP_EXP	GRANT_SYSPRIVS_EXP

AUDIT_EXP

Undocumented dbms_aq_exp_queues.audit_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

AUDIT_SYSPRIVS_EXP

Undocumented dbms_aq_exp_queues.audit_sysprivs_exp( version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       outVal BINARY_INTEGER;

       retVal VARCHAR2(60);

      BEGIN

        retVal := dbms_aq_exp_queues.audit_sysprivs_exp('3', outVal);

        dbms_output.put_line(outVal);

        dbms_output.put_line(retVal);

      END;

      /

      

      PL/SQL procedure successfully completed.

CREATE_EXP

Undocumented dbms_aq_exp_queues.create_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

DROP_EXP

Undocumented dbms_aq_exp_queues.drop_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

GRANT_EXP

Undocumented dbms_aq_exp_queues.grant_exp( objid IN NUMBER, isdba IN BINARY_INTEGER, grantor OUT VARCHAR2, version IN VARCHAR2, new_bloc OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

GRANT_SYSPRIVS_EXP

Undocumented dbms_aq_exp_queues.grant_sysprivs_exp( version IN VARCHAR2 new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       outVal BINARY_INTEGER;

       retVal VARCHAR2(600);

      BEGIN

        retVal := dbms_aq_exp_queues.grant_sysprivs_exp('23', outVal);

        dbms_output.put_line(outVal);

        dbms_output.put_line(retVal);

      END;

      /

      1

      SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','"SYSTEM"',TRUE);

      

      PL/SQL procedure successfully completed.