Oracle | DBMS_AQ_EXP_QUEUE

Oracle DBMS_AQ_EXP_QUEUE_TABLES Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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.