Oracle | DBMS_AQ_EXP_QUEUE

Oracle DBMS_AQ_EXP_QUEUE_TABLES 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

ALL_QUEUES	DBMS_AQ_SYS_EXP_ACTIONS	OBJ$
DBMS_AQADM_INV	DBMS_AQ_SYS_EXP_INTERNAL	USER$
DBMS_AQ_EXP_ZECURITY	DBMS_AQ_SYS_IMP_INTERNAL

Documented No

First Available 19c

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

INSTANCE_CALLOUT	SCHEMA_CALLOUT	SCHEMA_INFO_EXP
INSTANCE_INFO_EXP

INSTANCE_CALLOUT

Undocumented dbms_aq_exp_queue_tables.instance_callout( name IN VARCHAR2, schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2);

BEGIN

        dbms_aq_exp_queue_tables.instance_callout('UWEXP', USER, 32768, 1, '23.2');

      END;

      /

      

      PL/SQL procedure successfully completed.

INSTANCE_INFO_EXP

Undocumented dbms_aq_exp_queue_tables.instance_info_exp( name IN VARCHAR2, schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       nblock PLS_INTEGER;

       retVal VARCHAR2(30);

      BEGIN

        retVal := dbms_aq_exp_queue_tables.instance_info_exp('UWEXP', USER, 32768, 1, '23.2', nblock);

  dbms_output.put_line(retVal);

        dbms_output.put_line(TO_CHAR(nblock));

      END;

      /

      
      

      
      ORA-01403: no data found

SCHEMA_CALLOUT

Undocumented dbms_aq_exp_queue_tables.schema_callout( schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2);

exec dbms_aq_exp_queue_tables.schema_callout('C##SH', 0, 1, '23.2');

      

      PL/SQL procedure successfully completed.

SCHEMA_INFO_EXP

Undocumented dbms_aq_exp_queue_tables.schema_info_exp( schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       retVal VARCHAR2(60);

       nblk BINARY_INTEGER;

      BEGIN

        retVal := dbms_aq_exp_queue_tables.schema_info_exp('C##SH', 0, 1, '23.2', nblk);

        dbms_output.put_line('retVal: ' || retVal);

        dbms_output.put_line('New Block: ' || TO_CHAR(nblk));

      END;

      /

      
      retVal:

      New Block: 1

      

      PL/SQL procedure successfully completed.