Oracle | DBMS_AQ_EXP_QUEUE

Oracle DBMS_AQ_EXP_QUEUE_TABLES Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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, '21.1');

      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, '21.1', nblock);

        dbms_output.put_line(TO_CHAR(nblock));

      END;

      /

      

      PL/SQL procedure successfully completed.

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, '21.1');

      

      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, '21.1', nblk);

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

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

      END;

      /

      

      PL/SQL procedure successfully completed.